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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives