Formula no longer working in Sheet Summary


I have a sheet with sheet summaries that were working for the last month and I recently updated with data shuttle and its no longer working. I keep getting the sum of 0 even though it was working before.

=SUMIFS([Quantity (G)]:[Quantity (G)], Material:Material, CONTAINS("200002", @cell), [Pick-up Date]:[Pick-up Date], @cell > TODAY(-90))

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Hmm... So we have actual dates in the date column, actual numbers in the sum column, and consistent data types in the id column. I wonder if it is the CONTAINS function not liking the fact that it is looking at numerical values.

    Try converting that helper column we've been using into a text/number column and enter this:

    =Material@row + ""

    Then adjust your SUMIFS to look at this helper column for the CONTAINS function.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!