if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )

Good morning!

I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column "Complete Date". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount.

I am just learning Smartsheet so any help would be great! Thank you!

Tara

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Can you provide the exact logic similar to...

If [Column name]# = specific criteria, output this.

If [Column name]# = this other criteria, output this.

so on and so forth until all possibilities are covered?

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.