-
URL for a row of data
Does anyone know if there is a way to get a url link for a specific row in a sheet? So, when they click on the link it will take them to that row.
-
Ideas on how to handle complex projects with LOTS of sub-tasks
I am working with on of our departments internally on their Smartsheet system, and looking for insight into how some of you handle complex project plans. What they have right now is so bloated that it is unmanageable, and making them rethink using Smartsheet as a system at all. for context, they went from using Google…
-
Adding additional rows to PMO a Project Metadata Sheet + Project Category ideas
Hello! Has anyone ever added multiple Project ID rows to a PMO Project Metadata sheet? Each one of our projects will have 7 component ('project') plans so I would like to have those included on the project metadata sheet. I did a test and added each component to the Intake sheet and then copied/pasted the first row on the…
-
Public Holidays
Hi, When we update our public holidays, it doesn't seem to pull through on project plans that were created 2017. Can someone please advise how we can get smartsheets to automatically update projects plans that were created in 2017 with 2018 public holidays? Please note that I have updated smartsheets with the latest public…
-
How to get report to show up in sheets folder?
Hello all, I have a Smartsheet report that I can access from the home area or if I click the link directly. However, when I go to sheets, it is not showing up. In the second image, you can see there are no reports, only sheets. Is there a reason that the report is not showing up in the sheets folder? Does it take a few…
-
Need Data Grouped by Month in Chrono Order on Dashboard
Hello! I have data that I am grouping by month in a report. But when I try to chart that data on the Dashboard, it will only put the months in Alphabetical order, not Chronological order. I tried adding a helper column to assign numbers (1-12) to the months. Of course, that put them in the correct order but then the data…
-
No Activity Users on User Type Admin Center Report
In the User Type Report or any user report, users are part of your count which impacts your overall cost, for 365 days after their last interaction with an asset. When I run the User Type Reports, I have internal and external users with no "Last Activity" date and the # of assets viewed, commented, edit or created the last…
-
standardized x-axis range on a line graph
When using a side-by-side comparison of data with the same benchmarks, but different data points, is there a way to standardize the x-axis range so that the benchmark line in the two graphs are aligned?
-
How long do untransferred items remain in the account
If I am transferring a license from one person to the next but I click the "do not transfer items", they will remain on the account accessible to any shared user - correct? Will they expire after a period of time, or will they just remain out there?
-
Return Value based on two criteria
I have a hard time explaining this, but will try my best. I attached a spreadsheet example to illustrate. I want to lookup a value first based on the customer to return the assigned manager. If there is no Customer, then I want to look at the group to return the assigned manager. What is the best way to go about this.…
