Formula to calculate Completion % based upon STATUS not time

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.

Find more posts tagged with

Accepted answers

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.