Invalid operation with IF Formulas

Hello Smartsheet Community,

I am struggling to figure out this IF Statement.

Smartsheet tells me this is a Invalid Operation

=IF([Use Case Development % Complete]@row = 1, "Completed", IF([Use Case Development % Complete]@row = <1, "In progress", IF([Use Case Development % Complete]@row = 0, "Not Started")))

What am I missing? This worked for another cell.

Find more posts tagged with

Formulas

Accepted answers

All comments

Yanis Kyr

The issue is with the = < 1. You can either use equals OR less than but not both.

On a different note, you should put the =0 argument before the <1 (the way you currently have it, the <1 will always be valid before the =0 and you will never see "Not Started").

=(IF(% complete@row = 1, "Complete", IF(% complete@row = 0, "Not started", IF(% complete@row < 1, "In Progress")))

Yanis.

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.