Try to capture Minimum and Maximum dates

dpm1028

I set up 2 columns ("Start Date" and "End Date") on a sheet. I would like to populate the heaer of the column with the minimum Start Date and the maximum End Date. But I just get the error "This Column is restricted to dates."

AravindGP

Hi @dpm1028

It looks like you've enabled project settings in this sheet. So, if you simply indent rows 2 to 4, the dates will automatically be populated with the earliest start date and the latest end date as row 1 will be considered as a parent.

AravindGP

Hi @dpm1028

It looks like you've enabled project settings in this sheet. So, if you simply indent rows 2 to 4, the dates will automatically be populated with the earliest start date and the latest end date as row 1 will be considered as a parent.

dpm1028

THANK YOU!!!!