Airtable Rollup Field Bug Report

[icese7en]

Description

There appears to be an issue with Rollup Fields when used in conjunction with Linking Records and date columns. The problem occurs when the Rollup formula becomes more complex.

How to Reproduce

1. Create a Rollup Field that references a date field in Linked Records.
2. Set the Rollup formula to MIN(values).
   • Result: Some records correctly display dates (as expected, since not all linked records have values in the corresponding date field).
   • 
3. Change the Rollup formula to a more complex one, such as: IF(MIN(values) = BLANK(), "-", MIN(values))
   • Result: All records now display "-" instead of the expected dates.
   • 

Expected Behavior

The complex formula should behave similarly to the simple MIN(values) formula, showing dates for records where they exist and "-" for those without dates.

[TheTimeSavingCo]

Interesting!  I experimented a bit and think this may specific to `MAX()` and `MIN()` specifically.  For example,

MAX(values) & " Test"

outputs as:

0 Test

May want to open a support ticket directly!