-
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…
-
Automatically Updating Start and End Dates
When converting a project to a template, the start and end dates are usually no longer accurate. Is there a way to change all the dates without manually doing so one by one? For example if a template had 12/31/2025 as the due date, and I want the new project to be 12/31/2026.
-
2 of 2: How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Continuation of 1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for…
-
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…
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
-
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…
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…
-
Merged: Document mapping from PDF
This discussion has been merged.
-
Copilot Frontier integration
Microsoft now has an official Smartsheet Sheet connector for Copilot. It indexes Smartsheet content so Copilot can search and reason over it inside Microsoft 365. It's in BETA right now. What are some of your success stories / plans for this? Apparantly this can enable: multi-step work across Microsoft 365 applications,…
-
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…