-
Formulas in Reports - Any way to speed up?
Currently, I have a report connected to a single sheet. This sheet contains various formulas, including cross-sheet references. When data is added to the report, the formulas will not update/work unless the sheet is refreshed. Is there any way to have the formulas values "pop-up", or otherwise load? It is somewhat…
-
Automating date tracking and reminders
Hello, Im building a long-range fiscal quarter date tracking sheet with preloaded due dates over multiple years . I need reminders to notify the assigned person only when the item is active , still unsubmitted, and within 30 days of the due date. I also want to avoid excessive reminder frequency. Also i want to generate a…
-
Open Sheet in New Tab When Select Hyperlink in Report
I would like to be able to open my linked sheet in a new window when I select the hyperlink from a report. I have very lengthy reports that pull in hundreds of sheets. When reviewing data, I'll expand and collapse grouped data as I work my way down the report. I occassionally need to navigate to the underlying sheet to…
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
-
Incurred hours not showing for future dates within the same month
Hi everyone, We are using Smartsheet Resource Management for capacity planning, operational follow‑up, and monthly financial reporting, and we have a recurring challenge related to how Incurred Hours are handled in reports. We understand that incurred hours are date‑driven (past vs. future), and that this behavior is…
-
Help!
I have a vision i know what I want but I cant seem to figure out how to do it. Anybody up for a zoom or teams call to help me?
-
How do I add horizontal lines to a stack chart for my Dashboard?
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
Merged: Allow formatting of Report Cells
This discussion has been merged.