Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable Rollup Field Bug Report

Topic Labels: Formulas
235 1
cancel
Showing results for 
Search instead for 
Did you mean: 
icese7en
4 - Data Explorer
4 - Data Explorer

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).
    • icese7en_0-1725930874279.png

       

  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.
    •  
      icese7en_2-1725930944806.png

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.

 

 

1 Reply 1

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!