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
-
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, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/
Answers
-
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, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
@Amit Wadhwani it worked! Thank you so much! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!