Start a new topic

if then else help

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!


Hi Mary, did this work for you? We'd love to hear!

Thanks,
Jeff
Thank you! I had figured out the if field = yes one, but I could not for the life of me figure out how to return the current date on the other one. I plugged in the code for that and it does indeed work THANK YOU!
Login or Signup to post a comment