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:
is there an ability to set a conditional format based on two columns in the same row:
completed (column) date is later than the due (column) date – the cell turns red
completed date entered is before (or after) today's date
Yes, there is! Thought its kind of hidden. After you set up a conditional formatting you have to click on the arrow to the left of the condition and add another condition. See Screenshot.
Hi all, I have a sheet "Transition Tracker" where my team adds data that can often change throughout the lifecycle of a project. When this data is initially added, I have an automation that copies it to another sheet used by another department. I need to add a formula to the other department's sheet that will update a…
Hi all, I have set up a form and workspace, this has multiple sheets and dashboards so that each form filled in finds its way to the correct sheet and dashboard. But when each form is completed on a sheet, the original sender does not receive an alert to inform them the form is now closed. I have 6 different sheets so what…
Hi, I'm trying to determine whether Smartsheet has a feature similar to a heat map, where cell colors automatically adjust based on changing values across a column. Since the values are constantly changing, using fixed conditional formatting ranges isn't practical. Is there a way to color cells relative to the column…
