-
Approval Workflow with Attachment in Response
I'd like to design an approval workflow wherein I need to automatically attach the same PDF file in all of my Approved Response email. Would that be possible? or my only option is to include a download link from Onedrive or Googledrive in the response so the recipients can get the PDF file?
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
Unique countif on a multi-select use case
I have a sheet where we are trying to do a count of project for each person. Here is the information: The sheet lists all the services/applications that a team supports. There are potentially multiple team members assigned to support a service/application. We also have projects that may or may not span across the…
-
Copying data from Smartsheet to Excel with Power Automate
Hey all, I'm trying to back up my smart sheet important data by copying it into an Excel sheet. The issue is that I get array of rows that should be the column of the row that was copied from smart sheet. See attached pictures. I don't understand why I cannot get a variable for each column in specific row Data On smart…
-
Using a Database to Autofill Cells
Hi Smartsheet Community! I am trying to create a cell autofill for email and phone in one sheet using another sheet as a database. The issue I'm running into is how do you select between identical names with different email/phone. In the database sheet, I've created a duplicate checkbox column with a formula that will…
-
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…
