-
How do I fix contact names not appearing in the cells of a sheet?
When selecting a contact from the dropdown list in a 'Contact list' type column (used to assign leads for tasks), only the email address appears in the cell when a contact is selected, but in the address book the name + surname and email address is listed for each person. How can this be fixed? Thanks
-
Return multiple values based on two cells.
Using a VLookup I was able to get the budget manager column to return the multiple values based on the paying department. However, I also need it to return another person if the grant option is selected. The budget manager column on the first sheet is used for a filter on a dynamic view to allow only the contact and budget…
-
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
-
Can you parse a summary field from a report into another report?
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.
-
Project Selector in Dashboard
I have a Portfolio Dashboard, In tht we have multiple domains and each domains have multiple projects. I have created a main Dashboard which is having a link of Portfolio and each domain overview dashboard. I have individual project Dashboard also Now in each domain Dashboard i want to include a project selector and as…
-
Gantt Chart Report Formula Blockage
Hey Smartsheet, At current we are unable to change the end date in a report if it is linked to a gantt chart as the formula that links the start and end date stops this. It would be great to find a way around this so our PMs can update end dates in forms. Kind regards, Arthur
-
Editor - Sort Rows greyd out
Hi all, I’m running into an issue in Smartsheet where, as an Editor, I’m unable to sort rows using the column header menu. I’ve checked for the usual culprits—there are no parent/child relationships in the sheet, no active filters, and no locked rows. Despite this, the sort option still isn’t working. Has anyone else…
-
Create new document/grid/etc. in existing workspace
Currently, when I select the Create button in the left menu, I can select from a number of templates and document types but it automatically puts it into a new workspace. I need the option to add this to an existing workspace. Rarely ever do I want to create a new workspace. If I do, I'll go to my folders! How is this not…
-
Cross-sheet formula references in table view, now generally available!
January 22, 2026 Many users manage complex projects across multiple interrelated sheets and rely on formulas to consolidate data, calculate key metrics, and generate portfolio-level rollups. A critical part of this workflow is the ability to reference values from other sheets—commonly known as cross-sheet formula…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…