Sheet Summary

Hi Team!

I have an invoice tracker, and I'd like to use the sheet summary to indicate 2 different fields: "Total Paid" and "Total Due"

My columns are "Amount" and "Paid Date" "

For "Total Amount" I am using =SUM(Amount:Amount).

"Total Paid" - If a date is populated in the "Paid Date" column, calculate the the total sum from the "Amount" column.

"Total Due" - If the "Paid Date" column is left blank, calculate the the total sum from the "Amount" column.

Thank you ahead of time for your help!

Find more posts tagged with

Accepted answers

All comments

Paul H

Total Paid =SUMIF([Paid Date]:[Paid Date], ISDATE(@cell), Amount:Amount)

Total Due =SUMIF([Paid Date]:[Paid Date], ISBLANK(@cell), Amount:Amount)

FlyFlip

Thank you Paul for the quick response! It worked perfectly!

If it is ok, I have another question. I noticed on the sheet summary there is an option for a contact list, date, dropdown, etc but I haven't figured out how to utilize them. It is my assumption that if I chose dropdown for example, I could list all the projects I have invoices for and when I chose the project it would calculate everything for that project but that doesn't seem to be the case. Can you explain to me how to utilize those sheet summary options? I tried researching it but nothing that gives detailed explanation or examples.

Paul H

@FlyFlip Sorry I havent had any need to use those summery sheet options. Maybe someone who has used them in a solution can offer some help

Andrée Starå

Hi @FlyFlip

I hope you're well and safe!

Yes, you can use the Sheet Summary fields as a selector. I do that all the time in my client solutions. I also use it to collect default values on each row in the sheet and more.

More info.

https://help.smartsheet.com/learning-track/level-2-intermediate-users/sheet-summary

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

FlyFlip

Hi Andree,

Thanks for Smartsheet reference, but I have viewed that before and it still doesn't help me understand how to utilize the contact list, date, dropdown, etc for the Sheet Summary.

Are you able to show me an example how you utilized it?

Thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.