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 children when date from another column is older than TODAY()
Comments
-
csprocket777,
I have figured out a solution to your issue, but it involves adding one more column. I don't know whether you can achieve the desired result by modifying your formula, but ultimately it becomes simpler by breaking it into a two step process, as follows:
- Add the new column which determines whether the date is prior to today, and if so, displays the Column3 value. If not, the result is 0. This is achieved through this formula: =IF([Column2]2 < TODAY(), [Column3]2, 0)
- Then you can derive the sum of those that are earlier than today with the following formula: =SUM(CHILDREN()).
I am including a screenshot of the whole thing. Let me know if you have question.
Steve
-
So this is a formula that goes in each child cell? I was hoping to operate entirely in the parent row.
Let me try this...
-
This works. It would be ideal if I didn't have to copy the formula into each new row as rows are created and that it work in the parent row exclusively.
-
I get closer when I do something like this:
=SUM(COLLECT([Column3]:[Column3], [Column2]:[Column2], <TODAY()))
-
Hi csprocket777,
your original formula is wrong
=sumif(children([column2](your row number), <today(),children())
you were missing the row number to indicate the what is the parent cell
hope it can help
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives