-
Use Reports to create graphs on Dashboards
I think with the extreme power of reporting on smartsheets and being able to get all the data you want in one place from multiple sheets, you should be able to link the report to create a graph rather just embedding the report into your dashboard. You can do both the report embedded but create a graph with the data as well.
-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
-
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates) based on predecessor. On my past project, this was no big deal; however, on my new project, I have been asked to track down…
-
Add rows to a sheet through a report
Is it possible to add rows to a sheet through a report? Is a certain permission level required for this? Thanks!
-
Work around for duplicates to only show the most updated row
Hi, I have a list of names that were entered to the sheet more than once (but a different value in other columns). I have a helper column to identify which are the duplicates, but is there a way to show only one of the updated one in a report? Source Sheet Test 1 & Test 2 are duplicates, but I only need the newer enter to…
-
Include Column Description in Update Request Form or Form to Update Existing Rows
It would be incredibly helpful if the column descriptions were included in the update request form. We will request information from users who do not have access to the sheet and likely will be unfamiliar with the type of information that should be included in the column. Forms allow help text, this should also be a…
-
How to get symbol to automatically update in destination sheet when it updates in the source sheet
I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol in column L of the destination sheet to match the symbol in column M of the source sheet when the rows of columns A, B, C, D,…
-
Advice for Primary Column
What would you recommend I use as a Primary Column on this sheet? Here are my columns and their type: * School Name: Drop Down * Month: Drop Down * School Year: Drop Down * Total Volunteer Hours: Number/Text * Submitter: Contact List * Comments: Number/Text Most of the columns are Drop Down or Contact Lists which can not…
-
Populating a Multi-Select Column from Excel
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this window. :/ I appreciate any and all help. Teri
-
Editors Reordering Columns
Hello all, As I've read in Smartsheet Articles, the only roles that can change column layout are Owners and Admins. However, in one of our workspaces, we noticed an Editor changing the order of the columns in a Sheet. Are we missing something and is this expected behavior? If no, what can we do to fix this? We don't want…