IF OR Statements not working correctly
I have a question on 'IF' 'OR' statements. I researched and created one that looks like it should work. I am trying to display a status field with 'Completed' or 'Cancelled' and I have the field to start with an auto-fill - from the form with 'In-Progress'. I tried making each statement in its own field to display separately, but that wasn't working and it was a mess. Then I found with 'OR' I could combine them all, and I get argument statement not found or data not recognized. Can someone help me with this? I was placing the below in a separate "function" column to hold this since I have the Status column auto-populating with 'In-Progress' from the form when submitted.
=IF([Item Ordered]@row= "1", Status@row, "Completed", IF(OR([Supervisor Review]@row = "Decline", [IT Approval]@row= "Declined", [Funds Certifier Approval]@row= "Declined", [Approving Official Approval]@row= "Declined", Status@row, "Canceled"))
Answers
-
Tyr this in the status column:
=IF([Item Ordered]@row= "1", "Completed", IF(OR([Supervisor Review]@row = "Decline", [IT Approval]@row= "Declined", [Funds Certifier Approval]@row= "Declined", [Approving Official Approval]@row= "Declined"), "declined", IF( |insert the criteria that results in a cancelled status | , "Canceled", "In-Progress")
Set this as a column formula so it overwrites the form default. In fact, you can remove the form default because the formula creates an In Process status if none of the criteria are met.
The formula looks at the item order column and if it equals 1 it makes the status Complete. If not, it looks at the supervisor, IT, funds certified, and approving official for a decline. If any declined then it makes the status Decline. You'll need to add the criteria that results in Cancelled. I couldn't tell from your formula. If none of the previous criteria are met then it marks the status In Process.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!