-
Move Row Automation lagging terribly
I'm leapfrogging rows from a form collection sheet to an intermediate sheet, and that move row automation works fine. From the intermediate sheet, I'm moving rows to the main data sheet. This is where things are lagging, like stopping for multiple hours for no reason. The rows that are moving have only 5 columns. There's…
-
Simple Automation Not Working
Hi Everyone, I have set up the following automation: Unfortunately, the automation does not appear to be working: I've saved the sheet and refreshed the page multiple times. Can someone help me troubleshoot? I have a very similar automation set up on a similar sheet, and it's working just fine.
-
How do you automatically pull assigned tasks to an individual's 1:1 sheet?
Elaboration: We would like to have our employee 1:1 sheets automatically populate with all tasks that are assigned to who that 1:1 sheet is designated for. Example: Pamela is assigned tasks in sheet 1, 2, & 3. When Pamela opens her 1:1 sheet, we would like to have the tasks assigned to her in various sheets automatically…
-
Question about cell linking and automation
Hello, I have recently been put in charge of several sheets that were managed by someone no longer on our team. I have experiencing an issue with one of the sheets adding in data and I am not sure where it is coming from. The way the sheet that I am having issues with works is that it pull in a Transaction Number and then…
-
Re-submit for approval
I'm trying to work out a workflow that allows someone to re-submit for approval. I'm not sure how to record an update to a previous denial. Sequence Request submitted-> Approval Request to VP VP Declines-> Notification sent to requestor Requestor updates request (existing request in sheet) -> here's where I lose the…
-
Hello,
I am currently working on a digital performance evaluation. I have created a smartsheet with employees names, supervisor email, 30 day review date, 60 day review date, and 90 day review date. I have created a smartsheet survey for the employee to complete and a survey(evaluation) for the supervisor to complete. I would…
-
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…
