Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Nested If Statement
I have been struggling for a long time trying to get a formula to work for me. Here's the issue... I have two IF statements that work fine independently of each other, but when I combine them I keep getting an 'incorrect argument set' error. Here is the formula, and if someone could help me out with this I would be very grateful.
=IF(AND(ISBLANK([Last Follow-up Date]1), ISBLANK([Work Order Date]1), ([Estimate Creation Date]1) < TODAY() - 21), ([General Interest Level]1) <> "Decisive Selections Made", 1, IF(AND(ISBLANK([Work Order Date]1), ([Last Follow-up Date]1) < TODAY() - 21), ([Building Phase]1) <> "Beginning", 1))
Comments
-
Hi!
You have a few too many parentheses. I'm not sure this is correct as you didn't specify all the parameters you needed for each result. But I think I cleaned it up for you. Also, there was no final Else result, so I added 0.
=IF(AND(ISBLANK([Last Follow-up Date]1), ISBLANK([Work Order Date]1), [Estimate Creation Date]1 < TODAY() - 21, [General Interest Level]1 <> "Decisive Selections Made"), 1, IF(AND(ISBLANK([Work Order Date]1), [Last Follow-up Date]1 < TODAY() - 21, [Building Phase]1 <> "Beginning"), 1, 0))
Give it a shot.
Shawn
-
That worked! Thank you so much, Shawn--I really appreciate the help!
Randy
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives