-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Fiscal Reports
There are quite a few workarounds that have to be designed for Fiscal reporting in underlying assets. New idea is to have a way to have capability built into reporting for integrated options for both calendar dates as well as fiscal dates. Or to toggle between calendar and fiscal month. Week, Month, Quarter, and Year.
-
Report will not average negative values correctly for baseline variance.
Hello, I have a project sheet that calculates Variance from the schedule baseline. I am trying to create a report from this sheet that shows the average Variance for each supplier (from the Assigned to column). As you can see in the image, some of the variance values are negative, and some are positive. When I try to use…
-
Grouping On Reports for Individuals Utilizing Pro Account/ Adding another plan tier
Hi, I am a business owner and like using Smartsheets for collecting information from my clients and track various information. I used Smartsheet at a former employer and really appreciated the grouping function to create charts, graphs, etc in dashboards but don't have that functionality with my current Pro account. I…
-
Using a column for multiple summaries in a report
I would like to be able to use the same column in a report multiple ways. My current use case is for project durations in our portfolio. We have a report that shows by Division the count of projects and their average durations. I would also like to be able to show Minimum and Maximum durations but I cannot select the…
-
Dynamic View Not Allowing Temporary Sort
I have a dynamic view that is pulling from a report that contains two source sheets and does not have any default sorting. When I try to temporarily sort the DV by date, it loads and refreshes as if it is sorting the data, but nothing gets sorted. All of my columns in the DV are behaving this way. What is going on?
-
Time Tracking
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
-
I am receiving errorCode: 48 on one of my sheets
I am receiving errorCode: 48 on one of my sheets that is in a Workspace. All other sheets can be accessed except for the most important one. I have created 2 cases for this with no response from Smartsheet: Case# 08756481 Case# 08759594
-
Automation Daily Trigger
I have an automation set up to email certain team members if values change on a sheet. The trigger is set to Daily so that it doesn't send them a bunch of emails every time I add data. What I want to know is, at what time do these usually run? I want to make sure that it is not sending out the email before I have finished…
-
Report not filtering all of a sudden anymore
A report that I use everyday is all of a sudden not filtering anymore. It is a big report that is way over the 2500 that can be displayed. Normally I can filter by a work order and will pull up all info that goes with that work but fore some reason it is not filtering now.