-
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)
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
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…
-
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…
-
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
-
Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
-
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…
-
Can't see sheets in workspace
A colleague of mine and I are working on a project. We've created workspaces and sub-workspaces for different work areas. She is the workspaces owner. I'm an admin. For some reason, she can't see the sheets in the sub-workspaces. I see the sheets, but she can't see them. Again, she is the owner of the workspace folders.…