formula for multiple criteria

shaziya upadhye · 02/22/24

i am looking for a formula to track progress / multiple statuses

migrated = 100%

decommissioned= 100%

In Progress = 50%

Incomplete - reporting error = 0%

Not Started = 0%

Failed in PROD = 50%

Decom Candidate - 0%

what formula can i use to get a update in a column if any these statuses reflect

shaziya upadhye · 02/22/24

Got a formula that worked for me

=IF(Status@row = "Migrated", 1, IF(Status@row = "Decommissioned", 1, IF(Status@row = "In Progress", 0.5, 0)))

and then use % to that cell

shaziya upadhye · 02/22/24

Got a formula that worked for me

=IF(Status@row = "Migrated", 1, IF(Status@row = "Decommissioned", 1, IF(Status@row = "In Progress", 0.5, 0)))

and then use % to that cell

Best Answer