Sign in to join the conversation:
Is there a way to alert the user when, for example, they check a box, but other conditions are not currently being met?
I see I can send emails and Slacks and whatnot, but I just want something to appear on screen.
Thanks!
Hi John,
You can use conditional formatting for this.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
We use to have validation messages in MS Access, I have not seen this feature in Smartsheet. Like the reply says above, you can raise a visual alert by changing the formatting of the row, or a cell instead.
You could also set up an IF function to display a word or phrase in a column based on the validation - but it isn't the same as an onscreen validation message.
Good question btw!
Kind regards
Debbie Sawyer Consultant & Training Manager
Smarter Processes mean happy people in successful businesses
I'm using a sheet for a project plan. I have a % Complete column and a manual dropdown column for Status (options are Not Started, In Progress, Completed, At Risk, etc.). I want to change the Status column to "Complete" when the % Complete for a task is changed to 100%. Screenshot of my automation set-up is below. Can…
Hi, I have a large project plan, and sometimes I get lost among all the information when trying to locate specific tasks in the Gantt chart. Does Smartsheet have a feature similar to Microsoft Project that allows you to quickly scroll to or find a task?
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?
