Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I have Finsh date clearly and have put another column for Actual finish. If the Actual date is before or after the original Finish date I would like to be able to format it. Is there a way to do this?
Christian,
By formatting, you likely are looking for Conditional Formatting.
You can't use formulas directly there, so you need another column.
A checkbox column with this:
=IF([Actual]23 <> [Actual finish]23, 1)
will set the check box true when the Actual and Actual finish are different.
You can then use Conditional Formatting on that field.
Hope this helps.
Craig
