Start a new topic

If field not blank then use current date

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!

1 person has this question
1 Comment

Login or Signup to post a comment