Check date and flag On

Técnica Engenharia

I want to check by dates if you need to call the customer by activating the red flag, this red flag will serve as a pending call to a customer CRM spreadsheet.

It is working correctly, it happens that when the date cell is empty the flag is turned on, can you ignore when there is no date to compare?

=IF([Call in date]3 < (TODAY() - 30); 1; 0)

L_123

=IF(and(not(isblank([Call in date]3)),[Call in date]3 < (TODAY() - 30)); 1; 0)

try something like that.

Técnica Engenharia

#UNPARSEABLE

thanks my dear for the help but it doesn't work

Andrée Starå

@Técnica Engenharia

Hi,

There was one parenthesis to much after -30.

Try something like this.

=IF(AND(NOT(ISBLANK([Call in date]@row)); [Call in date]@row < TODAY() -30); 1; 0)

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

=IF(AND(NOT(ISBLANK([Call in date]@row)), [Call in date]@row < TODAY() -30), 1, 0)

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

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Técnica Engenharia

Thank you very much, the problem was solved, were the commas.

I am from BRAZIL, it must have occurred because of this configuration.

Andrée Starå

@Técnica Engenharia Excellent! Happy to help!

L_123

Whoops. My bad. Glad you got it sorted.

Técnica Engenharia

I tried to use the formula in a common column and it works when I put in the column( % Complete column) to evaluate the progress of the error project

Project settings - Options / % Complete column

Thanks for help

Andrée Starå

@Técnica Engenharia Yes, % Complete can't have formulas when you're using dependencies.