Need help

claude.ngongang80316

Good Day!

I need help to fix the formula below. I am having this error message: Incorrect Argument Set.

Thanks in advance

=IF(Phase@row; "Analyse/Conception"; IF([Date Requise DC]@row - TODAY() <= 10; "Rouge"; IF([Date Requise DC]@row - TODAY() > 20; "Vert"; "Jaune")); IF(Phase@row; "Exécution"; IF([Date Requise MES]@row - TODAY() <= 10; "Rouge"; IF([Date Requise MES]@row - TODAY() > 20; "Vert"; "Jaune")); IF(Phase@row; " "; "Gris")))

Claude

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Claude,

Try something like this.

In your IF parts you wrote =IF(Phase@row; "Analyse/Conception" and it should be an equal (=) sign instead of the semi colon (;)

=IF(Phase@row = "Analyse/Conception"; IF([Date Requise DC]@row - TODAY() <= 10; "Rouge"; IF([Date Requise DC]@row - TODAY() > 20; "Vert"; "Jaune")); IF(Phase@row = "Exécution"; IF([Date Requise MES]@row - TODAY() <= 10; "Rouge"; IF([Date Requise MES]@row - TODAY() > 20; "Vert"; "Jaune")); IF(Phase@row = ""; "Gris")))

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

claude.ngongang80316

Good Day Andrée,

Thanks for the suggestion, I have the same error message #Incorrect Argument set. Thanks again for your help.

The proble I am trying to solve is as follow:

I need to assign health status to projects. In my tracking sheet, I have 2 phases, (Analysis/Conception and Execution). I compare the Analysis/Conception with a milestone and Execution with another. Hope this provide more insight.

Claude

claude.ngongang80316

Good day!

Finally it worked.

Thanks very much.

Claude

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!