Flag Trigger Formula

tlsisco33006

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å

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

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å

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

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

Andrée Starå

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

Give this a try...

 

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