I've been searching the forum posts but haven't quite found the answer to what I need. On a profile, I need to add a Virtual Field (Action Date) that will populate if (and only if) there is a specific value in one of the other Fields.
There are actually several options I have with this - I just can't seem to make anything work!
First, I need VF Column AC to populate with either the current date or the date that is found in regular field Column A.
Then, I need VF Column AC to populate if and only if either regular field Column T equals a specific value or if VF Column AB equals a specific value. The value for VF Column AC should remain blank in all other cases.
I have tried my hand at a custom function, but keep getting an error that the column can't be found.
Any and all help would be appreciated!