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 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
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
