# Re: Combining Two Formulas

Solved
3527 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi! I am trying to solve the following:

I have a lookup field that lists multiple dates multiples times (the same day in each respective record). Like so: 10/10/2022, 10/10/2022, 10/10/2022, 10/10/2022. This is the "Move In Date ~ Expansion" Field.

I only want one date listed and clean like so "MM-DD-YYYY". So I created a Formula Field ("Move In Date ~ Expansion (Calculation)" Field and did an ARRAYUNIQUE formula, however, it shows up with additional 0's and is not clean. How can I adjust this formula so that it lists the date of the lookup field only once and clean like so"MM-DD-YYYY"? Or does anyone have any other solve here? Thank you!

1 Solution

Accepted Solutions
18 - Pluto

Use a rollup field instead of a lookup field. Since all of the dates are the same, you can use the rollup formula

MAX(values)

2 Replies 2
18 - Pluto

Use a rollup field instead of a lookup field. Since all of the dates are the same, you can use the rollup formula

MAX(values)

5 - Automation Enthusiast

Thank you so much! That worked!