Conditional Formatting Question

Hello Smartsheets Community:

Does anyone know if there is a way for me to set a conditional format for the following scenario (use screen shot below):

For task line 394 (highlighted in green), I want to turn this row red when the end date for this task is more than 5 weeks from the start of task line 386?

Any help or suggestions that you could provide would be greatly appreciated.

Find more posts tagged with

Accepted answers

All comments

Anabisdally Castro

Hi Anthony -

I don't know how to solve that problem with pure formatting - what I would do as a workaround is create a column where I calculate the delta between the two end dates and then use that cell to apply the formatting against - if cell x is larger than 25days (assuming 5 working days a week) then apply your format to the entire row. Make sense?

Anabisdally Castro

Anthony D'Ambrosio

@Anabisdally Castro

Thank you for the response. I apologize, but I am having a hard time visualizing the formula to use. My thought was to write the formula as:

=[End Date]@row (>) [Start Date]386 + 25

In regards to the above formula the parentheses would not be around the greater than symbol. It was the only way that I could show that symbol in this comment section.

What are your thoughts and thank you so much for your help!

Best,

Anthony D'Ambrosio

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.