Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollup dates from formula's

Topic Labels: Formulas
947 2
Showing results for 
Search instead for 
Did you mean: 

I’m trying to do a “max” date rollup, where it returns the last date. This works on a regular date field. However, I only want to track this for “in progress” projects so I’m using a SWITCH formula to return the dates from records in progress. Once I try to rollup the formula field the “max” values aggregation no longer works.

Any workarounds or ideas? Thanks!

2 Replies 2

If anyone has a solution for this issue, I would greatly appreciate it.

Puedes utilizar la siguiente expresion DATETIME_PARSE(CONCATENATE(values))

Donde CONCATENATE te devolvera el string completo del date y con el parse lo conviertes a fecha.