-
Simplifying Index / Match function
Hi Community! My goal is to have a formula that indexes the "Status" column in my 2.0 WMTN sheet; i have built this formula however the below is only referencing 1 of 5 sheets, so i will need to recreate all the IF functions 5 times over…this isn't very efficient and there's a chance a new task can be added, which then…
-
Text to Number Issue
So the below formula however its resulting in a text result, i.e. left aligned. I'm then trying to run an AVG/Collect or AverageIF formula on this column however its providing a #DIVIDE BY ZERO result. Any idea/thoughts on how to resolve this? Below is the formula resulting in a 'text' result that I cant run a count/avg…
-
How to Filter on Blank Cells in a Multi-select Contact List Column
We have a ticketing system that has an assigned column that is a multi-select contact list column type. Before I switched it to multi-select I had a filter that showed the current user and any rows where the assigned column is blank. When I switched to multi-select the blank filter stopped working. I tried a helper column…
-
Generate formulas AI tool available in AU!
December 11, 2025 Generate formulas is now available for customers using the Smartsheet AU environment in Table view. This AI tool enables you to quickly create working formulas in the formula panel using AI, without needing to master complex functions or syntax. Simply describe what you want the formula to do in plain…
-
Dynamic View filter
I am revising a column in my source sheet. It has a dropdown window where I am adding more keywords. However, when I go to the dynamic view filters to search, the newly added keywords do not appear. Is there a limit as to how many items will show in a dynamic view filter dropdown menu?
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
Indexx Match Help
Hi, I am having trouble to make the Indexx Match work. Can anyone spend a few minutes with me to help?? Thank you Penny
-
If the checkbox is checked copy the row
I am having issues solving a problem. I have a sheet containing multiple columns (3 text/number, 1 date, 1 contact list, and 1 checkbox). Made out of around 150 rows. I want the rows copied to another sheet if the checkbox is checked. I tried: Using a copy row automation which works but rows are always copied at the end of…
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Formula Help Please
I am trying to get a proper formula to add the last total found to a number @row when name matches. I've attempted to use the AI feature but it never works. Please Help!