-
Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
-
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…
-
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
-
error al tratar de abrir una hoja que ya tenía cargada y trabajando.
Hola buenos días. Tengo problemas para abrir una hoja en la que ya venía trabajando sin ningún problema. Pero ahora que entro al ESPACIO DE TRABAJO correspondiente y pretendo abrir la hoja, no me deja. Me aparece el siguiente error. Por favor si alguien me puede indicar que pasos seguir para no perder toda la información…
-
Links Not Working
Anyone else having issues with links to other Smartsheet sheets not working on and off? This is the second issue I have had this month. My table is not populating with the little arrow for the link showing as red versus blue. Error message says: Error: this link is invalid because the linked cell has been deleted. But, if…
-
Data mesh: Merging between sheets
I have 3 sheets: 2 of them have their own forms to collect data, and 1 master sheet. The 2 individual sheets have questions which are similar to each other and questions which are completely different (they are 2 forms of questionnaires). The master sheet is used to merge the answers of the similar questions and all other…
-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
Will Smartsheet roll out an enhancement adding the ability to have more that 20,000 rows per sheet?
We use Smartsheet for several data repositories to feed data into other sheets via formula. We are running into issues because of the row limit in sheets. Will you be adjusting the sheet row limit, if so when?