-
Redisign how you merge e-mailed notifications for the same user
When you work with workflows and customized messages in workflows, the automation will generate separate notifications if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the system removes the custom subject and message body -> this merged notification results in the user…
-
Forward automation notifications when on vacation
Is there a way to have all automation generated notifications for user 1 be temporarily transferred to user 2 when user 1 is on vacation? We can do it by changing each automation workflow but this is not a good solution. Thank you, Neil
-
Add Links to WorkApps in Automation Messages
Currently when creating an alert automation you have the option to include Message Only, Link to Sheet and All Fields, or Link to Sheet and Specific Fields. We are trying to promote WorkApps instead of users accessing the source sheet, so it would be better if we had two additional options: Specific Fields with no Link…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Merged: The ability to send notifications to groups rather than individuals
This discussion has been merged.
-
Automate a report for user inactivity
Hi, I was wondering if there was a way to automate a report that could be emailed for all users who haven't logged into Smartsheets in an "x" amount of time. So for example, a report would run monthly and email me all users who last logged in over 3 months. Any information is greatly appreciated.
-
Automation using reference cell
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this monitoring is measured as the stages are marked as Complete. This calculation is straightforward with a formula that…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
-
Email automation with "Assigned To".
Text translated by moderator as per community is currently only supported in English, Spanish, German and Japanese. Hello everyone, I hope you are well. I have a question about an automation in my project sheets. One automation I'm implementing is an alert for when a certain project activity is approaching its due date. To…
-
Locking certain columns for parent row only
Hi, Is there a way we can lock certain rows of the parent row column so that no one can edit it? However, the child rows would not be affected by it. Thank you for your help!