-
Copying specific rows when specific dates are reached
I have built out multiple schedules on smartsheet for a couple of different departments. I'd like to copy all the rows of the different sheets for all the employees working that day to a centralized sheet. Then after 24 hours, the sheet gets wiped and it starts over. I'm looking through the workflows and I'm not quite sure…
-
I am trying to set an automation to trigger a daily email when a value in a cell is equal to 1.
I have the automation set up to trigger an email when the value changes from 0 to 1 but I also want to be sending a daily email if the value is 1 and does not change.
-
How do I set up my sheet to reflect changes made in another sheet?
Hello! I am new to Smartsheet and trying to figure out how (and if it's possible) to set up a workflow or formula to reflect changes made in another sheet. Currently, I have one sheet set up that's linked to an intake form. I am using this sheet as a "master sheet" to track all submissions. Additionally, within this master…
-
How to send out an alert when a row hasn't been updated by a certain time?
Maybe somebody else has run into my issue and found a creative and automatic solution. My setup is as follows: 1) I have a sheet where I capture the project status from 10+ team members. 2) It contains a 'Modified' column. 3) The sheet contains calculations that are updated whenever the sheet is being opened (e.g % of time…
-
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…