-
Issue with Future Dates and Global Time Zones
Hello Community, Looking for some help today to figure out how to correct time zone differences with dates. I have set up an Automation workflow to remove future dates in schedules and send notifications to the PMs. This would prevent future dates being collected in reports and dashboards. The settings for the Owner…
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Automation to Combine Multiple Row Attachments into a Single PDF
I’d love to see a feature or automation added to Smartsheet that allows users to automatically combine multiple PDF attachments into a single PDF. Use Case: I have a Smartsheet where we collect applications, and each application includes several supporting documents uploaded as individual row-level PDF attachments. When…
-
Workflow Update Notification Emails Not Highlighting the Updated Cell in Yellow
So, I am trying to set up a fairly comprehensive notification to my colleagues, when specific data regarding their assigned events change. I selected as many of the changes as I was allowed (19 appears to be the max). And while the automation seems to work, it isn't highlighting the cell that was changed in yellow. Which…
-
Does the cell history come over when a row is moved from one sheet to another
I have written an automation that moves content from one sheet to another when certain criteria are met. I thought the cell history came across with the row but when I click on "View Cell History" after it is moved, I only get the history for the move and nothing prior. Is this working as designed?
-
Abnormal Display of Hyperlink Content in Notification Emails
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
How to Get Attachment to Work on Automation
Hello All! I have an automation that is set as Trigger: When a Date is Reached —> Run Once on Date at 5pm. Conditions: Where two separate checkboxes are checked. Alert someone—> Message, Link to sheet and specific fields (an attachment). The automation worked except the attachment. It wasn't included at all on the…
-
File Attachments part of Smartsheet Forms Notification Email
The Smartsheet Forms currently do not include the attachments in the notification emails as soon as the form has been submitted. Therefore, the Approver and the End Receiver are not able to see the attachments instantly and will have to go to the link to access the table and download from there. We use the Smartsheet Forms…