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.
IF Statement Help
Hello,
I am new to Smart Sheets and apologise in advance if this is a simple question...
Scenario:
I have a sheet that is updated via a Web Form and i would like to have a Job Status updated depending on a few conditions:
IF the Operator is equal to Unassigned then the Job Status is Unassigned
IF the Operator is not equal to Unassigned then the Job Status is Assigned
IF the Completion Date is not blank then the Job Status is set to Completed
IF the Operator Assigned is blank then the Job Status is Blank
I can get the first part of the IF statement to work, but i cannot get the final 2 stages to work, my current syntax is as follows:
=IF(Operator_Assigned1 = "Unassigned", "New Request", IF(Operator_Assigned1 <= "Unassigned", "Assigned"))
Any help is much appreciated on this.
Thanks,
Anthony
Comments
-
=IF(AND(Operator__Assigned1="Assigned", Completion=""), "Completed", IF(Operator_Assigned1="Unassigned","Unassigned", IF(Isblank(Operator_Assigned1),"", IF(Operator_Assigned<>"","Assigned"))))
This should do the trick. Let me know if you have any issues with it.
-
Hello Mike,
Thank-you for the help.
I am getting the results of #UNPARSEABLE, I'm not sure what this means?
Thanks,
-
I use the following link to troubleshoot errors in formulas: https://help.smartsheet.com/articles/2476176-formula-error-messages
According to the UNPARSEABLE error, I would look to make sure the column names are accurate. If you've added spaces in any of them, surround the name in brackets like [Column Name]1
One thing I notice too is that I may not have the same number of underscores in your operator assigned column title. Double check that those are the same as what you have in your actual header and add or subtract from the ones I gave you, as necessary.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives