-
Connecting two Smartsheets (one a set list of assets, the other freeform)
I am trying to connect two Smartsheets. This is my current setup: The first Smartsheet (Smartsheet A) contains a list of shared assets, designated by an alphanumerical ID. When an issue is identified in one of these assets, it's set up so that when someone clicks the flag button, it notifies others. The second Smartsheet…
-
"Record a Date" should record current datetime instead of date
For automated workflows, there is an action called "Record a Date." It would be very helpful to capture the current datetime instead of just the date.
-
using fields in automations
Hello community! I'm working on an automation for a large spreadsheet of course owners. Some people own one course and some own 30. I'm trying to create an automation where course owners would only see the fields in the rows they are responsible for. I'm attaching images of how I set it up - for the test I'm just using my…
-
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…
-
Tired of messy image attachments in Smartsheet?
Tired of messy image attachments in Smartsheet? I built a small tool that lets you upload images directly into **cells (not as row attachments)** — making sheets much more structured and easier to review. 🔹 Before: Multiple attachments per row → hard to track 🔹 After: Images mapped to specific columns (clean & organized)…
-
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,…
-
Appointment Booking Smartsheet?
Hi There, Just wanted to come on and see if anybody on here has created a booking system on Smartsheet either using a sheet or form. I would require to have a selection of dates with duplicated time slots (example. there would be 3 available appointments at 9am on Tuesday). I can't think of a way of doing this where the…
-
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.
-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
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…