-
What formula is best to summarize dropdown lists by options?
Hello, I have multiple surveys with drop-downs that I need to summarize and create a dashboard. I need to know the number of times each option was selected. Can someone help me figure out the best way to do this? I am new and still haven't learned formulas. Thanks in advance for the help!
-
New to the community!
Hello, I'm Lillian. I am new to the group and looking forward to learning all the great things everyone here has shared. I started dabbling, but am looking to step up my knowledge. I feel like my biggest struggle so far is formulas. Looking forward to chatting with you all.
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…
-
References applicable by workspace
I really appreciate the current cross‑sheet reference functionality in Smartsheet but creating additional references for the same source sheet—especially after one already exists—can feel repetitive. It would be incredibly helpful if, once a cross‑sheet reference is created, that reference became accessible to all other…
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Stacked IF statement not evaluating all "value if false" options
I have 6 columns of dates that outline a chronological study process: Phase 1 Forecast date & Actual date, Phase 2 Forecast date & Actual date, and Phase 3 Forecast date & Actual date. I would like to consolidate these 6 dates into 1 column ("IX Study Status") that simply gives the current study status. I wrote a stacked…
-
Correct Formula Syntax for checking for excluding blank cells
I have a RAID log sheet where I want to add a helper column to capture the aging (duration) of each issue row that has not been marked as complete (and I want to convert the formula to a column formula). This sheet is generated for each project via our control center solution so there are several rows at the top of the…