Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 09, 2024 06:16 PM
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
- Create a Rollup Field that references a date field in Linked Records.
- 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).
- 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.
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 09, 2024 07:56 PM
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!
Reply
