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.Michelle Basson
Smartsheet Overachiever Alumni  Solution Architect  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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!