Formula to calculate Completion % based upon STATUS not time

rshoniber

What formula can I use to calculate if a task is Complete or not here?

My overall goal is to have the Project Plan calculate the % complete based upon the actual Status column vs the Start/End Dates.

I am essentially taking the PMO Template set and re-doing it to be based upon a Due Date we can set per task vs following the Start/End Dates with Duration and Predecessors.

Ray Lindstrom

Hi @rshoniber,

Try this:

=IF(OR(Status@row = "Complete", Status@row = "Canceled"), 1, 0)

Hope that helps!

BRgds,

-Ray

MichaelTCA

Hello @rshoniber

The IF function you want to use is almost there.

You will want to use the OR function inside of the condition. Smartsheet doesn't use AND/OR as operators. It's used as functions.

=IF(OR(Status@row="Complete",Status@row="Canceled"),1,0)