Hello,
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?
