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.

Sum Children() If Date <=today()

Kurt Mostrom

Kurt Mostrom ✭

03/21/17 edited 12/09/19 in Archived 2017 Posts

I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today(). Any thoughts?

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

03/21/17

Kurt,

You are looking for the SUMIF formula

This goes in the parent row's TOTALS column

=SUMIF(CHILDREN(DATE23), <=TODAY(), CHILDREN())

assuming your date column is named [DATE] and the row is 23

Hope that helps

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Count Report
Hello, I have a sheet with 7 columns each indicating a different team or step in our process (UX, Content, Regulatory Review, Planning, Execution, Data, Testing). I also have around 300 rows of tasks that need to hit each team/step. All cells in the sheet begin at "Not Started" As they move through each team, the team…
Blueprint not spinning up Generate Doc
I have a Map setup to Generate a doc in one of my sheets. This is connected to a blueprint and when I use the blueprint to spin up a new project the mapping in the sheet disappears, is there something I am doing wrong? Or a setting that I need to enable in my blueprint for this to work correctly?
Parent and child rows
Hello, I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complete all the rows under Milestone 5, how can I set Milestone 5 to show 100%? Thank you in advance for your help.