Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2016 Posts
Archives for March 2016
Discussion List
Formulas lost when moving rows within sheets
I keep an 'active projects' sheet, and move projects to an 'inactive' sheet to keep the clutter down. The formulas do not move with the rows though, which is annoying (sometimes projects come back to the 'active' sheet when new samples come in, and I am now having to copy and pasting formulas into those cells). Any…
Build overarching report on all changes made in Smartsheet
Hello- As the admin, i'm looking for a simplistic way of viewing all changes made (not just by sheet owner or sent to) but to anyone who has editing privileges. Can i create a single repot to view all changes made in Smartsheet (let's say) over the past week. Thank you.
Sights widget for Quarter over Quarter Status trend?
In the CIO Sight in the Sights gallery, what widget did they use to get the quarter over quarter status trend? Looking to do something similar and not sure how to go about it.
Publish Sights
Hi Team, We would love to be able to publish sights! This would be an amazing feature for us. We work closely with partners and leverage smartsheet to do so and often use the publish feature. We are working with sights more and more and would love to be able to leverage those with our patners!
Parent Row Rollup
Is there a way to rollup values of a custom column to a parent and other hierarchical parents without using the SUM function in each parent row? For example: I added columns A, B, and C. Column C = A * B. Is there a function or some other way to sum up column C to a parent row? Or do I need to use the SUM function in the…
Report sections
Is there any way to create sections within reports that have their own column headings? I want to combine two reports with mostly different fields into a single report to send to management. Using the standard report layout, I end up with a bunch of blank cells and long narrow columns. If there is no workaround for this, I…
Dashboard of sorts
Is there a way to manage/visualize your own projects at a glance to quickly review, track and update?
Is there a way to display elapsed time for a project?
Hey everyone! I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date? Thanks! Steve Stutz
What is the best way to consolidate data from multiple sheets to a single row
Hi, hope someone can help me. I am using smartshheet as an internal onboarding process. This process requires me to collect data from 2 webforms entry for same client that autofills 2 different smartsheets, one smartsheet with about 20 colums and other with about 35 columns, OR a single webform to a single master…
Is there a way to view task name in resource view?
Hello, In resource view is there a way to see the name of the task when I hover over the percentage? Currently it only shows the user name when I hover over the colored bar (not useful since it's the resource of the row anyways). Ideally I'd like to see the name of the task when I hover over the percent. (in attached…