So this is probably an elementary question but I"m still pretty new at this and trying to figure out how to do 2 functions with virtual fields and my brain can process a way to do it :)
If Column R is not blank then virtual field AA = current date, else virtual field AA is blank
also along the same likes but slightly different
If Column L = "Yes" then virtual field AB = Column F, else virtual field AB is blank
I'm sure there is probably a simple answer but I can't figure it out so help? THANKS!