Formula not responding
I'm hitting a bit of a road block. I think I am overthinking this more than what it should be but figured I would get a different set of eyes on my issue.
This is my formula
=IF([% Complete]@row = 0, "5Not Started", IF(Status28 = "6Complete", "2In Queue", IF([% Complete]@row = 1, "6Complete", "1In Progress")))
This is a screenshot of the row.
Based on everything how it is set the cell should be "1In Progress" Which it is not triggering correctly. Does anyone have any ideas on what I am missing here?
Answers

Good day @John P.
The IF statements in your formula seems to be contradicting to one another.
If you could add another screenshot where the headings of your columns are visible, that would be great.
Could you clarify the following:
IF(Status28 = "6Complete", "2In Queue",  with this section you are saying that if the status is Complete then make the status In Queue, is this what you want to happen? and is this formula in the Status column?
Is your intention to change the status based on the percentage completed?
for example:
if 0% then in Queue
if larger than 0% then In Progress
if 100% then Complete
if so, try this formula:
=IF([% Complete]@row = 0, "2In Queue", IF([% Complete]@row = 1, "6Complete", "1In Progress"))
I see you have a 5Not Started (which I have not included in the formula above). I am not sure what the criteria is for this? If you could give me the criteria for not started and in queue that would be great.If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Michelle BassonSmartsheet Overachiever Alumni  Solution Consultant  Lover of everything Smartsheet
https://www.linkedin.com/in/michellebasson/CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk 
Hello Michelle,
Thank you for your response. My initial code was just as you listed with % complete, but the 0% was the not started. The "5Not started" status is the default state.
Order of sequence.
If row 28 changes to "6Complete" than row 30 would change to "2In Queue".
if larger than 0% then "1In Progress"
if 100% then "6Complete"If none of these are true than "5not started"
Help Article Resources
Categories
Check out the Formula Handbook template!