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!