ISdate or ISblank

davidv
davidv
edited 12/09/19 in Formulas and Functions

I'm trying to achive this:

 

Field Maintenance: If my field Last maintenance date is empty, i need to put today's date, if there's a date i need to put Last maintenance date + Frequency (day)

 

Not able to make it works with isblank or isdate, any other idea?

 

thanks

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!