-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
What is the maximum row count for a report (I know there is up to 2,500 rows per page)
-
Build Report that Pulls Row and Summary Sheet Data
We are currently only able to build reports sourcing from EITHER row data or Sheet Summary data. The request here is to have an option to source from both.
-
Sharing reports with free users --- updated question
I had asked this question previously and thank @Shanky Paul for answering! I'm still trying to figure out if I give them access to the source sheet, will they be able to see the source sheet and if so, then why would I create a report? There is a column in the source sheet I don't want to share. Thank you!…
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
-
Creating monthly reports and accessing via dashboard
We use a sheet to track our monthly WIP (work in progress). How do I create a report for each month so that, if needed, we can go back to look at previous months to see the trend? I'll post a screenshot of a sample. We did this previously in Excel, had tabs for each month and the Prior Change column would populate from the…
-
TODAY() returns yesterday or tomorrow depending on your timezone
Hi Community, We have an interesting issue here in Melbourne, Australia when we use the TODAY() function. At various times of the day, it can return yesterday's date rather than today's date (as it should). Took quite a while for this to be acknowledged, but the behaviour has been confirmed now by a couple of senior…
-
Reference Hundreds of Sheets
Hello, I have hundreds of sheets that represent individual contracts. Every time contract is renewed, the current year is added to the sheet. I use a report to reference all the contracts and bring in information for the current year. I want to compare the year's contracts against the budget so I created a new sheet and I…
-
Dashboard Error
I have shared a Dashboard with internal and external stakeholders, but they receive the following error when trying to view. I have shared it with them directly through Smartsheet and also with the direct link. What am I missing here? The individual's shared on the entire workspace do not have a problem accessing it. Do I…
