-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Reports - Sorting & Grouping
Who can sort a report and group a report? I have a report that I made another member admin on - however they are unable to change the filters or group and ungroup Do they need to be admin to the underlying sheet?
-
COUNTIFS Cross Sheet Error
I have written these hundreds of times but for some reason I am missing something with this one. Simple, trying to count "Health" based on what we call Seq, in this case TSK. Building a metrics sheet for Dashboards. This formula is producing a Unparsable error and I cannot find the error. =COUNTIFS({DSV 3PL Schedule Range…
-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?
-
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?