-
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…
-
Simple Star Rankings
Here's a single formula to show star rankings (including half stars) for anyone who's interested: =IF(ISBLANK(Rank@row), "", IF(Rank@row = 0, "☆☆☆☆☆", IF(Rank@row = 0.5, "⯪☆☆☆☆", IF(Rank@row = 1, "★☆☆☆☆", IF(Rank@row = 1.5, "★⯪☆☆☆", IF(Rank@row = 2, "★★☆☆☆", IF(Rank@row = 2.5, "★★⯪☆☆", IF(Rank@row = 3, "★★★☆☆", IF(Rank@row…
-
Create a formula to return a check mark
Hello, I am looking for a formula that will return a check mark. Here is what I am using however it comes back #UNPARSEABLE =IF([Personnel Cost Metrics - Overtime]@row "<=3%", 1, 0) Appreciate the assistance.
-
Unable to Calculate Event End Time from Start Date and Duration
I’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields. We have a report that we pull into Smartsheet On Smartsheet: Request Start Time (Duration) Duration (duration field in minutes) Event End Time: (Duration) Formula's that I tried: =[Event Start Time]@row + ([Duration]@row /…