Nest-if Formula

Curt

Hi,

I am working in Smartsheet and am trying to create a nested-if formula to automate a status ball for a status column which is dependent on % complete for each request received. The goal is to great a red ball if a request is less than 70% complete and a yellow ball if the request is 70% or above and less than 100% and a green ball if the status request is 100% complete. I have tried multiple times to create the nested-if formula but keep receiving and error. Is there someone who can assist?

Kerry St. Thomas

=IF(PercentComplete@row=1,"Green",IF(PercentComplete@row<=0.7,"Red","Yellow"))

This formula should be a column formula in your Status column. As long as the Column type is set up to include Red/Yellow/Green, you should be set. HOWEVER… if PctComplete@row is blank, it'll behave oddly. You can add a level to make status gray in that case:

=IF(ISBLANK(PercentComplete@row),"Gray",IF(PercentComplete@row=1,"Green",IF(PercentComplete@row<=0.7,"Red","Yellow")))

More on IF (including an example of a nested IF statement):
https://help.smartsheet.com/function/if

Good luck!

Curt

Thank you !