-
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…
-
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?
-
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…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
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…
-
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…
-
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!
-
Help with a cross sheet formula: counting unique values when certain parameters are met
Hi there - I'm in need of a little help with a formula for a metrics sheet I'm creating. Metrics sheet looks like this: And I'd like the Units cell to display the a count of how many times a ID Number shows up in another sheet for the month and the year. In this case, the result for Jan 2025 would be 7 (since EQN187742 is…
-
Index/Collect?
I am looking for a formula that will take the "Date Manufacturing" entry for a specific lot number from Sheet 1 (my source sheet, see attachment) and have it automatically populate into a corresponding cell onto a secondary sheet (attachment 2) into the row "Date of Manufacturing" for that specific lot number. I have the…