-
When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
-
Merged: Mandatory Fields & Logic in Update Requests
This discussion has been merged.
-
Is there a way to exempt people from a Workflow Automation Process?
I created a Smartsheet for a team calendar. I created a Form attached to the Smartsheet for the team to request new "events" and be able to get them added to the calendar. Then, I created an Automation Process for Approval when "rows are added" and set it up to leave the row upon approval and delete the row upon rejection.…
-
AutoNumber Parent Rows Only
Is there a formula/ methodology to auto number parent rows only, preferably with a prefix style numbering sequence like the Autonumber column type uses?
-
Moving closed "tickets" to a second sheet
I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…
-
Autonumber is populating blank rows
I have a sheet set up with cross-sheet references. The autonumber function is populating blank rows. Is this normal behavior?
-
Return checkbox column to initial state after project scoping is complete
I'm trying to figure out if/how I can return a checkbox column to it's original state once a user has completed scoping a project. I've tried just about everything and keep running into roadblocks given my level of Smartsheet knowledge. For context: I've created a project scoping sheet that contains rows for all…
-
Is there a way to have copies of Smarsheet Form submittals be sent to emails in a contact list?
We have a Smartsheet form set up where people can submit requests. On the form there is a question where they have to put their supervisor's email. Is there a way to automate sending a copy of their submittals to the supervisor email they input in that contact list/question in Smartsheet? I'm already aware you can automate…
-
Multiple Location in One Intake Sheet for one project
Hello All, We will have one project that will have multiple locations (that has other information such as num of people, city, country, name etc...). Since we have one intake sheet and as the new project comes in, new rows gets created. Our current solution is to create just a separate location sheet where folks can go and…
-
"Workflow Timing Unavailable" Error Message
I am trying to set an automation to alert a contact weekly that there have been changes to certain rows, essentially I want to avoid multiple alerts and just have them sent once a week with all rows that were changed but it is not allowing me and pops up with the error message "Workflow Timing Unavailable". Is this not…