It then Question returning a date response

Answered - Pending Review

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?




  • Cancel this I have run an automation which works so problem solved. Thanks

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Blizz

    I hope you're well and safe!

    Glad you got it working!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.