If Blank, Today's Date Formula

mmac · 10/08/19

Hello,

I'm having trouble finalizing IF statement for the following:

If "Approved By" is NOT blank, the Date Approved = Today's Date

Thank you for the community support in advance.

Andrée Starå · 10/08/19

Hi,

Try something like this.

=IF(ISBLANK([Approved By]@row); TODAY())

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Approved By]@row), TODAY())

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

mmac · 10/08/19

=IF(NOT(ISBLANK([Approved By]@row)), TODAY())

worked for what I was looking for. Thank you for the support!

Andrée Starå · 10/08/19

I missed the NOT part!

Glad you got it working!

Happy to help!

Comments