Help with status column formula

Hello, I have created a formula to show the status as not started, in progress or complete when the %complete column is changed.

This is the formula

=IF(OR(ISBLANK([Due Date]@row)), “”, IF([% Complete]@row = 1, “Complete”, IF(AND([Due Date]@row < TODAY()), “Overdue”, IF([%Complete]@row = “0”, “Not Started”, IF([%Complete]@row = “1”, “Complete”, IF([%Complete]@row = “”, ””, ”In Progress”))))))

Please can anyone let me know what is incorrect as I am getting #unparseable

Thanks!

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

Yeah

=IF([Due Date]@row="","",IF([% Complete]@row = 1, "Complete", IF([%Complete]@row = 0, "Not Started", IF([Due Date]@row < TODAY(), "Overdue","In Progress"))))

Emily Salter

Thank you but it is still saying #unparseable :(

Kelly Moore

@Emily Salter

Check the column name %Complete in the formula. One reference has a space, one does not. Correct the misspelling of whichever one does not match your sheet.

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.