Date rollup formula

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 · Share on FacebookShare on Twitter

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 FacebookShare 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 FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list