How to have my status reflect a percentage complete

Jpurdom

Hello,

Column B has my dropdown option of Statuses (Complete, In Progress, Waiting, Not Started, & Escalated) Complete = 1, In Progress= .75, Escalated .5, Waiting= .25, and Not Started = 0

Column C is a percentage.

I would like to have Column C automatically update when column B has a dropdown selected.

Current formula =IF(Status@row = "Complete", 1, IF(AND(Status@row = "In Progress", 0.75)))

I am receiving an Unpareseable error.

Please help 😦

Darren Mullen

@Jpurdom You don't need the AND in there... and you don't have the correct arguments for it, so unparseable makes sense.

Try this:

=IF(Status@row = "Complete", 1, IF(Status@row = "In Progress", 0.75))