-
How can I exclude one column from an automation that alerts me to changes?
I have an automation set up to alert me when any field changes. I am not the one who does most of the data entry, so I just want to be sure that I stay updated on the changes. However, I utilize a calculation for reporting that shows me the day until an item is due. This field, of course, changes every day. Is there a way…
-
How can I dynamically redirect a form submitter to different URLs based on their form input
Hi Community — I’m hoping someone has solved a use case similar to mine. I’m trying to use a single Smartsheet form to route different audiences to different external URLs immediately after submission. Here’s the exact workflow I’m trying to enable: Advisor (customer) lands on our product page Clicks a single CTA → opens a…
-
Reports: Add Filter Option for "Current Month"
I want the following filter on Reports to have an option that is "equal to current month"
-
Multiple update requests get condensed into one illegible email.
When a sheet sends a batch of update requests to a recipient (timing based on automation), they get condensed into one email. None of the pre-chosen columns from the various rows show up and the email is undecipherable. Neither the email subject or the content is helpful for identifying what it's asking for.
-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…
-
Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hi everyone, I've been experiencing an issue with an automation setup and was hoping to get some insights or solutions from the community. Problem When I configure automation to send an email alert to a contact after a trigger change, the system groups email notifications together even though each has a unique value in the…
-
Including attachments in message only automations
I have created a message only automation (cannot include the link to the smartsheet) to be sent when a new row is added via a form. The form includes an upload of a document; however, when using a message only format for the automated email I am unable to include the attachments. Any help is appreciated!!
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…
-
Workflow Notifications for sub-subtasks
Hi, I set up a workflow notification to request updates on projects due today, or past due for an entire project sheet. But I would like to know how I can setup notifications only for the sub-subtasks row, if possible, without a helper column. Thanks!