Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIF invoice totals from the past 6 months
Hi-
I have a sheet that I input invoice amounts into for multiple outside contractors. I have the name of each contractor as a parent row and their invoices as the children rows. The columns are date, invoice number, billable items, amount and code name.
I want to create a formula above all parent rows that would SUMIF the "Parent Row" and the "Date" met the criteria. I cannot find a way to make the parent row as a criteria or the date criteria to be the past 6 months.
Comments
-
Here's a work-a-round. Create a new column "Amount Last 6 mo".
On all the children rows put this formula.
=IF(NETDAYS($Date3, TODAY()) < 180, $Amount3, "")
On all the parent rows put this formula.
=SUM(CHILDREN())
Does this accomplish what you're looking for?
-
Thanks Kris-
I tried the formula, but modified for my data. =IF(NETDAYS($Invoice Date2, TODAY()) < 180, $Amount2, "")
It is coming back as #UNPARSEABLE.
Any idea why?
-
Try this:
=IF(NETDAYS($[Invoice Date]2, TODAY()) < 180, $Amount2, "")
If your column name contains spaces or numbers at the end, you need to use brackets.
-
Perfect.
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives