If Blank, Today's Date Formula

mmac

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å

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

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

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

Andrée Starå

I missed the NOT part!

Glad you got it working!

Happy to help!