-
Auto Number column for only NEW rows
Hi - We have a sheet where we are tracking issues, and we'd like it to assign the next number in sequence once a new row is submitted via a form. Below, the "Issue Number" column is the primary column, so I cannot make this an auto-number column. What would be the simplest way to implement this? I cannot include other…
-
Merged: Email Delivery Change -Automation
This discussion has been merged.
-
Calendar Query - repeating item automation
Hi there Im creating a calendar for my team in SS - some items are repeating Weekly / Monthly / 1st Wednesday etc. How do I automate that rather than having to type each entry individually ? Thanks for your bright ideas 🌟
-
Approval Requests - edit and delete like Update Requests
The Approval Request feature (Approval Requests | Smartsheet Learning Center) is lacking some of the functionality of the Update Request feature (Update Requests | Smartsheet Learning Center). I want to edit or delete an Approval Request that is pending on the row, the same way I can edit or delete a pending Update…
-
Adding an Attachment from Dynamic View is Not Triggering an Automation
In my Dynamic view, I have allowed users to add an attachment (this is the only update they need to make to the row). In my sheet, I have an automation that is triggered 'when a row is changed' and an 'attachment is added or changed. The action is to change a cell value. When I add an attachment via the Dynamic view, the…
-
Possible to send MS Outlook email Templates once a task is reached
I am trying to set up outbound emails to send to external parties for their deliverables, setting timelines, and forms to complete once certain milestones/tasks are reached with in a project. Is it possible to have a email template built / added and have that template pull in information from the sheet summary such as…
-
Require Conditions to move card from one lane to another in card view
Is there a way for me to essentially "gate" the movement of one card from one lane to another in the card view? Essentially, I have a number of lanes "in planning", "in process", "complete" but I want user to be required to make sure specific fields (columns) are populated before moving from one lane to another… Is this…
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
-
Permission levels for blueprint created workspaces and folders
Hey team! I work extensively on control center and blueprints. We have a completely automated process set up where project managers can create their own workspaces and project folders using blueprints by only accessing the project intake sheet (i.e., they do not have access to the control center program). The issue that I…