Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional formatting for columns, informed by row-level input.
I am building a template for which the top row has date columns set up so that all date columns change color based on the date (today/tomorrow/yesterday). The first 2 date columns are, Start Date, End Date, and are not the concern. The remaining date columns, Milestone 1, Milestone 2, etc, are dates which are pulled from rows using "=[Start Date]XX".
The rows also have rules which change color of the row, based on date (today/tomorrow/yesterday), BUT also have a rule applied so that if a checkbox is checked, the entire row gets a strikethrough, and the rules which change the color of the row based on the date, do not apply.
I can not figure a way to change the color/formatting of the Milestone columns, based on their associated row-level input. I would like to have the Milestone columns change color to white/blank and/or have a strikethrough applied, when the associate row checkbox is checked. Could anyone help?
Thanks in advnace!