I have 2 date columns that are only completed on some projects. I need this rolled up to show the MIN of each of these dates on another table.
Arrayunique shows the value, but its not a date, its text.
Any other formula like if value then min will only show 0. Essentially any time I add Min to the formula it is showing 0 because of the blank cells.
Perfect - I had thought the OP meant the minimum of date 1 across all records rather than the minimum of date 1 and 2 for each record … if the latter this works perfectly - if the former then my solution may be what OP is looking for
actually It was the former, its looking at the min value of many projects dates connected to a single rollup.
@Russell_Findlay that is how I set mine up, but its showing 0. I did find a solve by adding a filter to the rollup settings to only refer to records where this value is not empty. But its odd I needed to do this as your example shows it should work like I thought it had in past. ill have to dig in why mine is not working without the filter.