It then Question returning a date response

10/13/21
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?


Cheers


Rowan

Answers

  • 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!

    Best,

    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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | 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.