-
Control Center and Collections
Anyone know if it's possible to have control center create a collection for each project that it creates?
-
Smartsheet Calendar isn't Sorting as Expected
I am working on creating a roadmap calendar for 2026. The source of the calendar is a report that pulls from multiple roadmaps across our Marketing department. I have the calendar grouped first by Marketing Pillar and then Pod (where applicable). It's worked alright so far but some feedback I've received is that our…
-
Timeline Widget - Custom Colors
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
-
COUNTIFS for multiple listed characters (not using numbers) in multiple columns
Good Evening Community, Column A contains the formula, see below Deliverables NOT Completed contains all the listed values I will need to incorporate in this formula. Deliverables Completed - (COMMS)/ Deliverables COMPLETED - (PROG)/Deliverables COMPLETED - (DEVE) all contain the same listed values from Deliverables NOT…
-
Card or Board View disappearing Column Titles
I am trying to set up a card or board view, so that they open a card, enter a whole bunch of numbers, and the final calculated values display on the card. However, since it's all numbers, the final display isn't particularly useful. I added into the equations to give them descriptions within the cell, for example ="Total…
-
Ability to remove "Submit" button on Forms
Having the ability to remove the "Submit" button on Smartsheet Forms would be helpful in cases where users need to go to a form to submit a request, but where we have exceptions to the rule. If they answer "Yes" to a specific question at the top of the form, then we show a dependency child question that says "Please reach…
-
SUMIF OR SUMIFS
I hope I can explain this correctly. I have three separate columns I am working with. My goal is to sum the total footage of certain rows that have been approved within the last 7 days. My columns are: FOOTAGE, STATUS, and DATE APPROVED. I would like to have a total in a separate cell at the top of the sheet. I keep…
-
Replacing all special characters in form query string parameters with a formula
Hello everyone! I am excited to be speaking at the "Leveraging the Query String in Forms" session at Engage 23! I wanted to share a formula that a customer and I developed to replace any special characters that could show up in cell when you are building a URL to a form with query string parameters using a formula. This…
-
How to avoid duplicate entries while submitting from forms
I want to restrict the duplicate entries in the sheet based on some column value conditions, I can be able to highlight the column but is there any direct method for avoiding duplicates.
-
Countif formuls
I'm trying to have a countif formula for a column that will count only if the space contains 100%, I can't seem to make it work, this is the formula I tried: =COUNTIF([FAT Completed]1:[FAT Completed]90, ="100%") anyone have any ideas