Nesting IF Statements to provide % Complete

Alex Knisely

Hello All,

I have a project sheet with the following status dropdown:

Not Started

In Progress

Ready for Review

Complete

Canceled

On Hold

Not Applicable

I'd like to write a nested IF statement to provide a value in a percent complete column. I've tried the following but get a #UNPARSEABLE response.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",100,)

I've tried many variations of the following, but can't seem to get it. Thanks for the help

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Alex Knisely

Typically, %Complete columns are formatted as percents, which means 100%=1, not 100.

If you give us the rest of your percentages, we can help you more specifically build your formula.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",1))

Kelly

All comments

Kelly Moore

Hey @Alex Knisely

Typically, %Complete columns are formatted as percents, which means 100%=1, not 100.

If you give us the rest of your percentages, we can help you more specifically build your formula.

=IF(Status@row = "Not Started",0, IF(Status@row = "Complete",1))

Kelly

Alex Knisely

Thanks, I was only focused on the syntax of it, and not the content (i.e. %s). I appreciate it.

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.