-
Multiple Notifications/Emails for single workflow
I put together a workflow that sends an email for approval, however whenever the project is approved it email blasts the contact who made the request (sends out like 7 emails/notifications) that all say the same thing. Is there a way to only have it send one? What could be causing this?
-
Why are charts appearing very pixilated and low quality?
Using latest version of Chrome, just updated it and cleared cookies/cache then restarted my computer. This has never happened before not sure what is causing it: I am zoomed in 100%, even at 50% or 150% the problem is the same.
-
How to set up and automate a template for this report chart in the dashboard?
Hi guys, do you know how to set up the following report chart in my dashboard? I have seen this kind of report chart in one of the Smartsheet webinars. My requirements to this report chart would be : Every time I set up a new project plan, every person in my "Assigned to" column should be automatically involved in this…
-
API, symbols column and user locale
Hi, Let's say a german coworker that created a sheet and is using symbols. These symbols are in german as well, while my locale is in english. Using the API, i can't detect that the sheet was created with a different language and thus can't detect that "Grün" stands for "Green" and makes the update with the API quite…
-
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…
-
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…
-
Creating a Master Project List and Dashboard
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which…
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don't want every person listed on the source sheet added to my formula sheet. I need a…
-
Cell Linking from a Form
Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it moves the cells I am trying to link down to the next row and will not transfer over the information. Is there a way I can do…