-
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.
-
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…
-
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…
-
Lock Filter so "Assigned to" can not turn off
I am looking to lock down a filter on a shared task sheet so that the assigned can only see their task. The filter has been setup and and applied as a rule to the sheet, but it appears that the assigned can turn the filter off and see all other task in the sheet. I do not want this to be happen, how can it be stopped? I…
-
Compare submissions
Hello! I would like to compare submission such that older submissions from same field "Name" are moved to different sheet. I can add a helper column called "Older" and would like to either populate the older rows with the word "Older," and number to signify it is older, or a simple yes/no dropdown. I currently have a…
