Flag Trigger Formula

tlsisco33006 · 12/11/18

I am trying to create a formula to trigger a red flag based on two variables: a date column and a drop down task column.

Here is the formula that I have created. What syntax do I use to look for an empty cell represented here with an "X"?

=IF(AND([Contact Date]1 =TODAY, [Contact Results]1 = X)

Andrée Starå · 12/11/18

Hi,

If I understand your question correctly, you will use "" to indicate that the cell is empty.

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

tlsisco33006 · 12/11/18

Thank you!! I tried the following formula and it returns a #UNPARSABLE. Can you tell if I am missing a part of the formula?

=IF(AND([Contact Date]1 = TODAY, ([Contact Results]1 = ""))

Andrée Starå · 12/11/18

Happy to help!

Try this.

=IF(AND([Contact Date]@row = TODAY(); [Contact Results]@row = ""); 1)

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

=IF(AND([Contact Date]@row = TODAY(), [Contact Results]@row = ""), 1)

Did it work?

Best,

Andrée

tlsisco33006 · 12/11/18

It didn't work. I have attached a screen shot.

Andrée Starå · 12/11/18

Ok.

It's difficult to see the details in the picture. Can you share the sheet or a copy with me?

Please remove any sensitive data before you share it.

Best,

Andrée

Paul Newcome · 12/11/18

Give this a try...

=IF(AND([Contact Date]@row = TODAY(), ISBLANK([Contact Results]@row)), 1)

Comments