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
M
Mary Sawatzke
said
almost 7 years ago
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!
Mary Sawatzke
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!