-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Different View of Report, depending on the location, from where the report is accessed.
I have a report called "My Tasks" in my workspace, I also have a shortcut to this report in my Dashboard. When I click the report from the Dashboard shortcut, the view is different from when clicked through the workspace itself. Different columns are seen in the two views, although I have set it to show only one. It even…
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
I want to add an "OR"statement
-
Is there a limitation for current user selection in reports?
Hi, I have not found any info on this in the community or in the help sources. Before I start to implement reports and dashboards with the "current user" feature, I would like to know if there is a limit to the count off concurrent users accessing the same report at any time? Greetings Stefan
-
Dashboard Report Widget: Columns Content and GANTT aren't in the same line
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is only when presenting in the widget. Is this a 'feature'? Thankful for any help
-
Dynamic push of data into Excel from a Report
Hey guys, I need some help as I 'm trying to automatically import some data from a specific colum displayed in a Report into an Excel spreadsheet and I don't really know how to do it... Here's the steps I've followed in order to have the data displayed dynamically in my Excel spreadsheet : #1 - I've created a report in…
-
How do I create an automatic updated sheet, that pushes information from other 2 smartsheets?
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be automatically added in the third. If anything gets UPDATED in the sources, the third needs to get updated.