Can you please confirm if I can actually use a formula field which depends on another lookup field? In my screenshot below, how do I create a formula field that will look for the Parent Agreement Date which is the agreement start date field in the parent record. Currently, this field is manually supplied, but I just wanted to know if I can change this to formula for faster processing. If this is possible, I plan to use Parent Agreement Number instead of Name since name can be duplicated in the system. Can you please advise me?
8 answers
