-
How do i change who the alert is sent from?
All of the alerts that are sent out from my Smartsheet have my name attached. I would like to change it from my name to either be erased or a generic name. Any idea on this one.
-
Connect sheets without manual cell linking
I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate sheet to be able to live update when changes are made. I don't think an automated…
-
moving row to multiple sheets
Hello, I would like to move one row to multiple sheets at the same time. I have a setup that utilizes what I call "duplicate tables" whose job it is to receive the row and move it to the corresponding table. The challenge is I need a duplicate table for each move which could get clunky. Has anyone had a similar need? I'd…
-
Smartsheets not staying saved.
Hi, I have a smartsheets that has a formula in that works out the number of days between a date and todays date. Therefore every day the No. days goes up and I have a dashboard off of this. The issue is that when the formula changes the No. days I have to manually go into the sheet and click save for it to get to the…
-
Manual Workflow Trigger for Time Base Automations
Hello all, I was setting up a Workflow to trigger based on a condition at a certain time of day. It did not work, which is fine it was a test, but now in order to run that same test again, I have to move the trigger forward an hour and wait for it to reach that time. (Function is to clear a checkbox daily) Since I am…
-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the review…
-
Using Forms & Automation to Drive Leads
Good afternoon Smartsheet Community, We use Smartsheet Forms sometimes for some client contact forms to track real estate or other sales leads. We found it helps to use Forms and Automations to make it super easy to contact potential clients in a timely manner. I broke it down step by step with video walkthroughs below:…
-
Automation - Run Workflow Daily
When an approval workflow is set to run daily, will the approver receive a single email each day containing all rows that need to be approved? Or will they still receive an individual email for every row that needs to be approved?
-
Problem changing cell value to checked
Hello, I have a question: I set an automation for when the value of a cell equals 'Submitted' or 'Resubmitted' and where the value of 5 other cells say 'Approved' a check box should be checked. The automation setup in my mind is: When X happens, and meets Y condition, do X I do not know why, but I am not able to get the…
-
How can I avoid reload of ID's that have been moved from active sheet to archived sheet
Dear, I have a sheet in which I'm uploading errors, which then need to be handled by other members. Those loaded errors are repetitive loaded for 14 days, but when a member is actually telling the error is closed it is moved to an archived sheet. Due to that move the error is fully reloaded in the error overview on next…
