Incorrect Argument Set

Hi All,

I have a formula that worked in one row, but then when I make it a column formula, it shows "incorrect argument set" in all the other rows but the 1st one. Please see below:



That's the formula:


=IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow"), IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow"), IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))


Can you help please?

Best Answer

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭
    Answer ✓

    Hi @angelapaj

    Can you try the formula below?

    =IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))))
    

    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/


    Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"

Answers

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭
    Answer ✓

    Hi @angelapaj

    Can you try the formula below?

    =IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Not Started"), "Yellow", IF(AND([CLIENT TYPE]@row = "Silver", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = "Review"), "Yellow", "Green")))))
    

    Best Regards

    Amit Wadhwani, Smartsheet Community Champion

    Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/


    Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"

  • angelapaj
    angelapaj ✭✭✭✭

    @Amit Wadhwani it worked! Thank you so much! :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!