Welcome!

conditional formatting using two date columns

Hi,

I use several date columns to track my project, for example, a start date, a finish date and an actual finish date. I want to apply conditional formatting so that if actual finish date is not equal to finish date, meaning a task can be finished ahead of schedule or a delay, then highlight that row. I tried conditional formatting and reports, but neither worked.

Any suggestions welcome!

Find more posts tagged with

Comments

sean59916

Hi -

I would add a reference column in your sheet with a formula like this:

=IF([Actual Finish date]1 = "", "", IF([Actual Finish date]1 = [Finish Date]1, "FALSE", "TRUE"))

Then create your conditional highlighting based on the reference column. See Attached images.

I hope that helps you out.

Sean

Arthur A

Hi, Sean,

I tried it and it worked -- Thank you!. However, with over 1000 rows in a single sheet, I would like to see a sheet level mechanism that serve this purpose from Smartsheet. For example, under "filter", I can simply show all the rows that the "actual complete date" is not equal to "finish date" by specifying this condition. Or as you said, use conditional formatting based on two date columns.

Anyhow, thank you again, and this is helpful for small projects.

Best,

Arthur

Sign in to join the conversation!

Quick Links

Trending discussions

Update Automations
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
Public links to sheets in automated emails?
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…
Generating documents from row data
This discussion was created from comments split from: Generate documents from row data.