Parent Row formula for Max date + 540 days

Peggy Parchert
Peggy Parchert ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm trying to use a formula in the Parent row of several date columns that will:

1) give me the MAX date from the child (anywhere from 1-12 rows)

2) add 540 days to that date (from #1)

This will work using: =MAX(CHILDREN()) + 540

Except if the child row is blank and then I get the error message #DATE EXPECTED

I've attached a screenshot. Any assistance would be greatly appreciated.

Peggy

Screen Shot 2019-08-30 at 2.52.04 PM (2).png

Comments