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 Z = current date, else virtual field Z is blank
also along the same likes but slightly different
If Column L = "yes" then virtual field AA = Column F, else virtual field AA is blank
I'm sure there is probably a simple answer but I can't figure it out so help? THANKS!