It then Question returning a date response

Hi There,

I am at a beginner level and want to automatically return a date result in a whole column. I think the formula should look something like this but it isnt quite working yet....


=if([Validation update request Completed]@row}ISBLANK([Lead Validation Date]@row,blank,date)


The Validation update request completed column is a checkbox that returns a check when previous conditions are met.

At that time I want the Lead Validation Date column to record the date of this event. Can someone assist with this simple formula error?


Cheers


Rowan

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!