I have used and tried each of these formulas separately and they work beautifully.

=SUMIFS([Total Savings]@row, [email protected], "IL5"

=SUMIFS([Total Savings]@row * 90 / 100, [email protected], "IL4"

=SUMIFS([Total Savings]@row * 50 / 100, [email protected], "IL3"

=SUMIFS([Total Savings]@row * 10 / 100, [email protected], "IL2"


In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date.

In Sheet Two, we want to add the dates associated with the percentage complete.

The existing formulas provide the percentages and totals but how can I add the dates for


We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order


Hi all,

Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me.

I have a supplier approval database with supplier info, several checkboxes for required docs, etc.

Also have an approval column, and then an approval reference column.

What i intend to do