Formula? Index/Match? Index/Collect?

PeggyLang

I would like to pull 'Store #' where 'GC Cost' $0.00

Not quite sure how to accomplish this.

I was thinking something simple like

=IF({GC Cost}>0,{Store #}@row.

However, that doesn't seem to be working.

Genevieve P.

Hi @PeggyLang

What about using a Row Report ?

That way you can show your two columns: the Store Number column and the GC Cost column, filtering by if the GC Cost is greater than 0, and it will surface all of the rows that meet your criteria.

Let me know if this will work for you or not!

Cheers,

Genevieve

PeggyLang

@Genevieve P. Thank you I hadn't actually thought of that. I do need to 'calculate' on the sum total of the $'s in the 'GC Cost' column. So I think I would have to have had a DataMesh that would take the data from the row report into a sheet so I could then aggregate or calculate on.

What popped into my head was ~

• create an automation that copies the row to another sheet when 'GC Cost' is added or updated

I think this solution gives me a cleaner less complicated way of getting the data isolated.

Thoughts?

Genevieve P.

Hi @PeggyLang

If you're on a Business or Enterprise plan, you can actually use the Summarize feature in a Report to create a SUM of the data in a column! I think this may be the easiest way to go with the least Smartsheet items or workflows to maintain.

Here's more information: Summarize content to extract key information with report builder

Here's a free webinar that you may find helpful: Redesigned Reports with Grouping and Summary Functions

Cheers,

Genevieve