Need assistance with formula

TinaM

I have this formula on a column =IF(Status@row = "Complete", "100%", ="In Progress", " %"), I want the user to be able to add in a number when the status@row is "in Progress". How can I write the formula to be able to allow the user to type in a progress level.

"In progress" may be 75% or 50%

Toufong Vang

Hi, @TinaM , you'll need a text/number column to store the user's reported progress level--something like Reported Progress Level. Your formula will be:

=IF(Status@row = "Complete", "100%", [Reported Progress Level]@row + "%")

This assumes that the status is either "Complete" or "In Progress".

If there are other possible statuses (e.g., "Pending Assignment", "Parking Lot", etc), then the formula will need specify when status = "In Progress":

=IF(Status@row = "Complete", "100%", IF(Status@row = "In Progress", [Reported Progress Level]@row + "%", ""))

Toufong Vang

Hi, @TinaM , you'll need a text/number column to store the user's reported progress level--something like Reported Progress Level. Your formula will be:

=IF(Status@row = "Complete", "100%", [Reported Progress Level]@row + "%")

This assumes that the status is either "Complete" or "In Progress".

If there are other possible statuses (e.g., "Pending Assignment", "Parking Lot", etc), then the formula will need specify when status = "In Progress":

=IF(Status@row = "Complete", "100%", IF(Status@row = "In Progress", [Reported Progress Level]@row + "%", ""))

TinaM

Thank you - This will work. I appreciate the assistance!