# Need help

Options

Good Day!

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

=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

• ✭✭✭✭✭✭
Options

Hi Claude,

Try something like this.

=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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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

• Options

Good day!

Finally it worked.

Thanks very much.

Claude

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!