-
How to include categories in horizontal axis while displaying independent colors for each series
I have a summary sheet with data I am using to include in a dashboard. My goal is to display this data as a bar chart where each cateogry is labeled in the horizontal axis and each category has its own color. I do not want to use a legend, the idea is the information can be quickly identified without cross referencing a…
-
How to calculate total time on Smartsheet
Hello, How can I calculate the total minutes on the smartsheet if I was able to obtain the start time and end time? I’m having some issues with the total minutes. As you can see in the last submission... if I do 1305-1245 it indicates 60 minutes. However, the real answer is 20 minutes. Please see the photo below: Many…
-
Can a recipient of an automated email request partially complete request?
We are in the process of updating hundreds of individual projects through the use of automated update requests. Even though we are breaking out the projects by dates, an update request to a specific person can require quite a bit of dedicated time. Can the recipient partially complete the "update request" without losing…
-
Add Legend to a Report within Dashboard (Widget)
Pulling a report that has colors (i.e.: risk bubbles, etc.) into a dashboard, does not look like there is a feature to add a legend, is this correct?
-
Issues with Form
Hello, I am having issues with my form: - When User fills out a form, they have to choose a department number from a dropdown. After the filled out form is uploaded into the sheet, the department number is changed? Example: User selects 577 in the form, but in the sheet it shows as 577.0 Here are some screenshots: The…
-
How can I easily identify all Reports impacted by a column name change?
I need to change a column name and, as we know, Smartsheet doesn't push the name change out to the Reports. Instead, it inactivates the old column within the Report. I need a way to proactively search (run a 'where used') on a column to see all the Reports its used in so that I can manually update each Report. Does anyone…
-
Report pulls in a primary column without me specifying it
I have a smartsheet, it has a helper column titled Full Name, which is calculated using task name and parent names. In the report section, I select the sheet, and the specific column and criteria. but then the end results shows me a column for task name which I don't want to see. I am not sure why it is showing it to me,…
-
Pro Account limitations and Employees' Training Records
I have to track about 70 employees' training records. My goal is to create one list of all employees and then have a way to click and see an employee's individual record. My question is, with the Pro account, I see I would be limited on file storage and one sheet per record. Would an employee's individual record use…
-
Action Tracker: single source of truth
Hello, I'm coordinating multiple workshops e.g. Technical, Communication, Training. I'm collecting findings on multiple smartsheets (one per workshop) and associate an action per finding. Reality is that during a Technical workshop, we have some Training findings. During a Communication workshop, we have a Technical…
-
Fix text-formatted numbers
I imported a lot of data from a PDF extracted to Excel then to Smartsheet. I tried to create a conditional format based on a column of numbers e.g. 1, 2, 3, 3.1, 3.2, 4 etc however it did not work. If I re-type the number in manually, it works for that row. My guess is the number is formatted as text. Is there a way to…
