-
Formula Assistance - Unparseable
Hello, I am trying to create a formula to count the amount of times 0, 1, 2, 3, 4, 5 were answered for each of the column categories wihtin the last three days to display on a graph on a dashboard. I was successful in creating the formula in a sheet summary, but cant get that to display correctly on a dashboard graph. So I…
-
Download Column Names & Column Types
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
-
Blocks for vacations
We use Dynamic View to report and schedule jobs for us (we don't use Resource Management). We don't use the calendar view as it would have too many assignments. I want to be able to put vacation times/blocks in so that my Ops manager will see the block as he schedules work weeks out.
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
Doing a mass update of sheet reference names
I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the…
-
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!
-
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…