-
Easier and shorter "If" formulas
Ability to select a value from one dropdown list, and then have a second dropdown list display only a limited number of options based on that first selection. Example: Column 1: Zip codes (user selects a zip code) Column 2: Flu vaccine dates (only the dates available for that selected zip code appear as options)
-
Is it possible to create a Template and share it to other users?
Hi, I have the following dilemma- I have created a really good PMO system within smartsheets using different sheets & dashboards, I would love to roll this out to other users within my organisation to utilise it as a template My question is, is this possible and if so how do I do it? For context I am a consultant and we…
-
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…
-
Why sheet requires saving when nothing changed?
This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus when I now click on another sheet, a dialog window prompts me to confirm to save my…
-
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…
-
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:…
-
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…
-
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…