Formula woes

Fairly new to Smartsheet and I can't get my formula to work, this is what I am trying do:

If Due Date in Children row is less than today and Status is Not Started "Red", In Progress "Yellow", Done and in Review "Blue", Complete and Closed "Green".

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

Dan_H

Hey Audrey!

If I am reading right, looks like you are looking at conditional formatting here?

Dependant on what dates you have you can format conditional formatting to look at dates and or status and then colour based on that

this video helped me with this: https://www.youtube.com/watch?v=1L6pIqPZyzg

All comments

Dan_H

Hey Audrey!

If I am reading right, looks like you are looking at conditional formatting here?

Dependant on what dates you have you can format conditional formatting to look at dates and or status and then colour based on that

this video helped me with this: https://www.youtube.com/watch?v=1L6pIqPZyzg

Audrey Marie

Hi Dan!

Genius! I completely forgot about conditional formatting, was so wrapped up trying to write a formula. I just did it and it worked, thank you so much for your help!!

Have an amazing day!

Dan_H

happy to help

have a fab day!

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.