-
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…
-
Looking for Smartsheet Consultant – Control Center (Client-Facing)
Hi! We’re looking for an experienced contract Smartsheet consultant to support a live client engagement. •Strong, hands-on Smartsheet experience •Control Center and other premium apps experience •Comfortable in a client-facing role •Experience working with live / production Smartsheet environments •Based in US or Canada…
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
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!!
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
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…
-
Reusing a formula, but it's not working. I need to calculate deviation on End date.
=IFERROR(IF([End Date (Projected/Actual)]@row = [Target End Date]@row , 0, IF([End Date (Projected/Actual)]@row > [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) + 1, IF([End Date (Projected/Actual)]@row < [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row…
-
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,…
-
Can anyone please advise if Im using the correct format for the current year function?
Hi, I'm currently updating my formula sheet and Im looking for a way to have the "Year" automatically follows the current year. Im using the YEAR(TODAY()) function but its not really working for me.. Appreciate if anyone can kindly advise if I missed out something… Thanks.
-
Formula to return the Month
Howdy. I have tried to type this in so many ways. I've googled multiple variants of formulas and always get unparseable. i must be doing something basic and wrong. I simply want CellA to look at the calendar date in CellB (the Created Column) and return the Name of the month. I've attached a screenshot. Any help would be…