Conditional Formatting Query

All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days.

I have used the Smartsheet AI tool but no luck, I have saved and refreshed.

I am using a helper column for my 5th rule in the list which asks the cell to turn grey. Do I need to use this solution here too?

Thank you!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/142323/conditional-formatting-query

Hi,

I hope you're well and safe!

Make sure the different rules are in the correct order. Try moving them around.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Louise Herridge

Hi I did try that previously, but obviously hadn't quite got the order right as just did it again and now working! Thank you.

Andrée Starå

Excellent!

Happy to help!

✅ Remember! Did I help answer your questions or solve the problem? Please support with 💡 ⬆️ ❤️, and/or ✅ Answer. It will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

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.