-
Make Single Line Form Entry into 18 Separate Rows
I have created a process using Helper Columns, Formulas and Automation that takes a 1 row form entry copies it into 18 separate rows based on the Sport Column and then copies those 18 rows into a 2nd sheet data sheet and then moves the entered row (Row 1) to an archive sheet. The theory was that when someone submits a form…
-
Why is my renamed sheet not being recognized in the automation sheet lookup?
I am trying to create an automation to move rows from a user entry sheet to a locked down sheet — I renamed the sheets with numbers to put them in order & to see the visual process flow. When I create the automation for the rows to move, the new sheet name is not being recognized & only the old name appears. When I test…
-
Mode date related features
When a date is changed on an action, we would like for SS to be able to determine if the new date is Before or After the initial date. This would be a real game changer for tracking projects deliverables.
-
Editable Comment Field for Approver When Declining
Add an editable comment field option when an automated approval request goes out so the approver can enter why they are declining a specific request.
-
Merged: Organising Structure For Automations
This discussion has been merged.
-
How do I force "Send from Triggering User" to send from sheet owner?
All three options for automated emails - are poor options, is there a workaround somehow? Send from Triggering user - We have a department full of people manually clicking a button which sends an email to clients, the client will not recognize their individual names. Send from Organization - My department has its own name,…
-
Nested If statements
I am new here, but cannot figure out how to make a nested if statement or an automation to change the status based on a date in the past. What I would like to happen is when any of these dates are in the past AND the check box is not checked the current status will change to "DELAYED". I can get it to work for one argument…
-
Same Level Multiple Approvals
Is there a way to sent out a request that contains multiple approvals? There is a situation where we have a record that may contain anywhere from 1 to 3 approvals. All approvers have the same authority. To tally the approvals I would create a separate column that evaluates the decisions of either all approved, all declined…
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
Some parts of the automation not running based on Index(Match) cell change
Hi folks, Could I get some help with this issue, please? Published sheets shared below. Workflow: Order Form Sheet - lists items (Primary column), has a Submit check box column (box is checked), and has a status dropdown column with an INDEX(MATCH) formula referencing the Tracking Sheet. Rows are locked. Tracking Sheet -…