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
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives