Formula with a range

Hi,

Calling on all formula guru's. I can get my formula to work for the absolute parts but when it comes to a range I get the #unparseable error. Below are the two formula's I've tried.

=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row > .01 and <.1, "In Progress")))

=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row = .01-.99, "In Progress")))

Thanks!

Find more posts tagged with

Accepted answers

Ayelet Weiner

If your Complete column is blank you can use this formula. This way you don't need to have a range.

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))

Let me know if that works for you!

Carrie Young

Thank you so much!

All comments

Ayelet Weiner

If your Complete column is blank you can use this formula. This way you don't need to have a range.

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))

Let me know if that works for you!

Carrie Young

Thank you so much!

Ayelet Weiner

https://community.smartsheet.com/discussion/comment/276891#Comment_276891

You're very welcome!🙂

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.