-
Data missing when moving rows to another sheet
Hi, I have multiple sheets has to move data to a master sheet in specific time.. But I find some data in master sheet are missing recently. It seems to happen when the moving data is more than 100 rows at a time. Some cells in rows didn't bring to the master sheet. in my case, the missing cells are from specific column,…
-
Automation - Copy Specific Cells to another Sheet
Looking for a way to copy specific cell to another sheet. I know how to do a full Row, but in the other sheet we are not looking for ALL of the columns and only certain columns are needed in the other sheet. Is there any option or creative solution for a flow like this? GOAL: copy the contents of a few cells ex.…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…
-
Assign Multiple Users from a Form
Good Morning, I have a form that has a few check boxes. Depending on what checkbox is selected, different people are assigned to a task, but it's for a single entry/row. Is there a way on a form to make the assign column (which is already set to a multi-contact) assign to several users in the single assign field from a…
-
automation failures
Both of these extremely basic automations fail to populate the requested fields. A form is used to add rows to the sheet, so I realize the status (1) default could be set on the form, but why doesn't this work? It should only trigger on new rows and should not require the additional criteria of "status is blank" because…
-
Automating Document Generation and Print
We would like to automate the following: "When a row is added, generate a specific document, and print to a specific printer". The idea is that the visitor to the office fills in a form with their details and then those details are printed on a label using a specific printer (using "Document…
-
Automation to change a date column from another date column?
We have a project intake sheet and a status sheet. When a project estimated completion date is changed on the status sheet, we want to update the intake sheet to reflect the new date. However, Smartsheet Automation can't change a date field with the "Change cell values" action and the "Record a date" action will only…
-
Is there an audit trail, activity log, or report that logs automated workflow activities?
I'm looking for a log or report that notates when automated workflow activities occur. For example, I created an automated workflow to send notification emails when certain conditions are triggered in our sheet. I don't necessarily need a read receipt, but was hoping to find where SS might log "message sent". I looked at…
-
How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having…
-
Automate Generate Documents
Is there a way to automatically generate documents when a new row is added?