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

Anthony
Anthony
edited 12/09/19 in Archived 2017 Posts

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    =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,

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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. 

This discussion has been closed.