Help

Re: Combining Two Formulas

Solved
Jump to Solution
4188 0
cancel
Showing results for 
Search instead for 
Did you mean: 
makasabian
5 - Automation Enthusiast
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
kuovonne
18 - Pluto
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)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
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)

makasabian
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much! That worked!