Need help

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

Best Answer

Answers

  • Andrée Starå
    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!

    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.

  • 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

  • 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!