-
Automation - When a request is approved I want to automatically copy to another sheet
I have an intake form and sheet for my team to review/approve/deny Press Requests. There is a separate sheet that is a calendar of all Marketing Activities, which press items are a part of. I want to create an automation that instantly copies approved Press Requests to the marketing Calendar. I only want to send specific…
-
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…
-
Retrieving Form URL via API
I have an automation that makes a copy of a folder and moves it into another folder using Make.com. Within the new folder is a sheet with a form, and I simply want to generate a QR code for this form using the form's URL returned by the Smartsheet API. I have come to learn that, since 2018, this functionality has been…
-
split a multi-select form response into multiple rows
Apologies if this idea has already been submitted. I've seen several people post this in the discussion forum, but did not notice posted as an idea. It would be amazing, if Smartsheet had a way to split multi-select form responses into multiple rows, without a complicated formula or the need to use a 3rd party.
-
Need to find the whether the task done on time or not with DATE + TIME Functions
3 Teams handle this Deadline, 1 day each. Total Deadline 3 Days. Each day 24 hrs deadline. Ex: Received Date/Time 06/08/26 7 PM to Due Date/ Time 06/11/26 7 PM. ( 7 PM is not fixed irrespective of time, but we need 3 working days as deadline not 7 days - Mon to Fri) 1 Scenario: Team 1 If Received Date/Time has text value…
-
Duplicate an automation from one sheet to another
I would like the ability to copy a fully configured automation from one sheet to another. This feature would allow users to duplicate an existing automation, including its structure, logic, conditions, and message content, and then simply update the column or field names as required for the new sheet. Often the column are…
-
Splitting multiple form answers
I've seen a few workarounds for this, that usually require another party or app. I've also seen "basic" formulas using INDEX, for this, but as someone who is VERY new to Smartsheet, I'm hoping for some additional guidance. I created a form, essentially for class registration. Sometimes people sign up for 1 class, sometimes…
-
Dynamic View Approval Workflow BEFORE cell data is allowed to change
I have a large sheet with 17 columns. I plan to build out a Dynamic View to limit what data is viewed and by whom. I'd like to build out a revise-and-approve process for cell data. For example, let's assume the project lead needs to update the detailed description (Detailed Description column) of a project. I'd like to…
-
Merged: Column Auto-Complete Options or Change it Back
This discussion has been merged.
-
Allow System Admins to View and Manage All Active API Tokens Across the Enterprise
Description: As a Smartsheet System Admin for our enterprise account, we need the ability to view, audit, and manage all active API tokens created by users in our organization. Currently, admins have no visibility into which users have created tokens, when they were created, what they’re used for, or whether they’ve…