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 past dates dependent on other past dates
Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target. If the Actual happened on the same day or before the Current Target, the format stays black.
We haven't found an option in the SmartSheet conditional format menu that lets a cell's format depend on another cell's content. We can only choose one "in the past" condition. We can't choose "further in the past than Column 12". Please advise?