sum total of items when due date exceeds a certain date
Hello! I am trying to create a formula that will sum total a quantity at row if the finish date at that same row is greater than a certain date. In the screenshot the quantity to be totaled is in the SCO Spec column if the finish date on that same row is greater than "06/30/2023".
Best Answer
-
@Kim Miller You can use the SUMIFS function for this:
=SUMIFS([SCO Spec]:[SCO Spec], Finish:Finish, @cell > DATE(2023, 6, 30))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
@Kim Miller You can use the SUMIFS function for this:
=SUMIFS([SCO Spec]:[SCO Spec], Finish:Finish, @cell > DATE(2023, 6, 30))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Some questions:
1) Is the reference date of "06/30/2023" static for the duration of the project, or is that variable / changeable?
2) You are only listing one value to Sum (SCO Spec), are there multiple columns that need to be added? Or are you looking for a total of the SCO Spec for everything that is beyond that date?
=SUMIF(Finish:Finish, >DATE(2023, 6, 30), [SCO Spec]:[SCO Spec])
This formula would sum all values in the SCO Spec column, where the finish is past 6/30/23.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Thank you so much @Jeff Reisman. The formula you shared worked perfectly!
@Colleen Patterson the 6/30 date is static and I only need to add one column. Appreciate your response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!