Date rollup formula

Elayne Smith

Elayne Smith ✭✭✭

02/27/25 in Formulas and Functions

Hello -

I am trying to replicate the date rollup to parent lines that automatically happen with the primary date columns used in project settings

0 ·

Best Answer

Melissa Yamada ✭✭✭✭✭

02/27/25 Answer ✓

Hello @Elayne Smith
Try:
Start Date: =MIN(CHILDREN())
End Date: =MAX(CHILDREN())

Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
1 · Share on Facebook Share on Twitter

Answers

Melissa Yamada ✭✭✭✭✭

02/27/25 Answer ✓

Hello @Elayne Smith
Try:
Start Date: =MIN(CHILDREN())
End Date: =MAX(CHILDREN())

Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula Help - if cell = X then show network days
I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =NETWORKDAYS([Date Open]@row, [Actual Closure Date]@row) . So we want the cell to show "duration to close" when status is…
Count Duplicates Only if the Field is NOT Blank
I am struggling to get the formula right to solve this problem. My formula can count if there are duplicates in this field, but it also counts it if the field is blank (because many rows won't have a value in this field). Can anyone help me add the "if it is not blank" piece so i only get a 1 if there is a value in the…
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…