-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Undo a automated workflow
Is there a easy way to undo a workflow. We need to delete emails sent to users via an automation. Can Smartsheet support assist with that?
-
Column Formula Alternative?
I have people entering information into a sample request sheet using form that allows the user to select multiple types of tests they would like to have run. The form populates "Sheet 1" and I'm using automations to create multiple lines on the destination "Sheet 2" using this solution: In the Source Sheet: Count of Rows:…
-
Can I add an attachment to an automation?
I want to specifically send out the same PDF file when an automation I have set up on the sheet is date triggered. However, I don't want to have to add that attachment to every single row. Is there way to do that without attaching the file to 1700 rows?
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…
-
Ability to run triggers on dates populated by the cell information more than once
Hi, When doing triggers for automation and when using the when this date is reached, if you want to have the trigger repeat every couple days you would need to set the date in manually instead of having it fill by a column date. It would be nice to have it be able have the trigger every couple of days ability for a date…
-
Smartsheet and Business Central integration
Hello All, I'm trying to integrate the Business Central projects table with the Smartsheet. I want to create a new project sheet in Smartsheet whenever a new project is added to the Business Central. However, it seems the Create a sheet option is not currently available with the PowerAutomate. Did anyone face the same…
-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…
-
How to replace a blank field with contents from another
Hi Community I need help, I have an onboarding form where there are many addresses to be captured. The registered company address is mandatory The main address is optional on the form as only needs to be filled in if different from the registered address. That is great for the form but on the smartsheet I need both filled…
-
Hour notification
Hi, When a user marks a row as in progress and it is still in progress 4 hours later. Is it possible to have the manager notified 4 hours after it was marked in progress and if it is still marked in progress.
