I keep getting #Incorrect Argument Set I am not sure where my formula is wrong - IF(AND(....
I want a "green" symbol to populate when the Office and month from sheet 1 match Office and Month in sheet 2 and the date completed from sheet 1 is less than or equal to the date due on sheet 2
Below is the formula that is giving me trouble.
=IF(AND({Completed on_CSC} <= [May Due Date]@row, {MODrpt}, Office@row, {RptMonth}, May$1, "Green"))
Thank you for any help
Merit
Answers
-
The incorrect argument set error means there is an issue in your formula syntax, usually a misplaced parenthesis or comma. I think I can see one of each in yours.
Can you try replacing the commas within your logical expressions with an equals sign. The first is correct, but the second and third are not (suggestion in bold here)
=IF(AND({Completed on_CSC} <= [May Due Date]@row, {MODrpt}= Office@row, {RptMonth}= May$1, "Green"))
And then move the closing parenthesis for the AND to be before the value if true for the IF (in bold here)
=IF(AND({Completed on_CSC}, <= [May Due Date]@row, {MODrpt}, Office@row, {RptMonth}, May$1), "Green")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!