Sign in to join the conversation:
I cannot get this formula to work. Any suggestions?
=IF([% Complete]1=0%,"Not Started",IF([% Complete]1=100%,"Completed","In Progress"))
Hi Scott,
Smartsheet looks at the numbers in a column formatted for percentage (for example, a % Complete column) as values between 0 and 1. Use decimal values (examples: 0.25 for 25%, 0.5 for 50%) to get the correct comparison, as opposed to whole numbers.
Try this.
=IF([% Complete]@row = 0; "Not Started"; IF([% Complete]@row = 1; "Completed"; "In Progress"))
The same version but with the below changes for your and others convenience.
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Completed", "In Progress"))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
