-
ISO 8601 date format
The ISO 8601 standard defines an internationally recognised format for representing dates and times, ensuring logical ordering from the largest to the smallest unit (YYYY-MM-DD). This system eliminates regional confusion and guarantees that dates sort accurately as text. Considering agentic solutions such as Copilot…
-
Contact List validation
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…
-
Scheduling automatic reminders for Proof reviewers
Here is a way to create reminders for Proof reviewers. This solution will: Send a reminder 5 days after the initial invite, if no one has responded to a Proof review request. Send a reminder 5 days after the last reminder, if no one has responded to a Proof review. Reset when a new Proof version is created. Some useful…
-
Merged: Document mapping from PDF
This discussion has been merged.
-
Help with a loop in Bridge
I have a child workflow set up to calculate the length of time a row has been on a sheet and write that time value to a column on that row. This child workflow does work but it is written using a specific sheet ID and row ID. And here is the parent workflow And the error I'm not sure which keys and values I need to enter…
-
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.…
-
Remove automation recipient from a workflow
We have several automated workflows that need to be cleaned up and I cannot find the name of a previous recipient. Is there a way to find a name other than search each workflow?
-
Tableau x Smartsheet Integration
Being able to feed dashboard charts from tableau data/import tableau data into grid sheets/reports.
-
Formula to insert date and/or time
Hi All, Whilst I use a 3rd party app for shortcuts when typing, its fully functional in Smartsheet. I am seeking the formula to insert the date in a text field while typing. Example in MS Excel the formula is &[Date] however this doesn't work in Smartsheet. I use Smartsheet via Microsoft Edge.
-
Update cell with the value from another cell
I need to be able to update the values in one cell when another cell has been updated/changed. I do not see an option when selecting "Change cell value in" to be able to have this point to another cell. I have tried putting {{cell reference}} in the dialog box but that just returns the text {{cell reference}} and not the…