Hi Everyone,
I’m newbie on Airtable. I want to make my first formula.
I want to know the latest date. I try to use Max, but the result is zero…
I used this formula :
(first colum is Starting date, last colum is used for the formula)
Data in “starting” column look OK, since is able to calculate the MinDate in the summary…
Any idea ?
Thank you!!
Best answer by kuovonne
Welcome to the Airtable community!
The MAX and MIN functions are a bit tricky to use when working with dates. They do not work well with lookup fields, and lookup fields also tend to be tricky to use in formulas.
Instead of using a new formula field based on the lookup field, try creating a new rollup field with the same linked field as the lookup field, and use the formula
MAX(values)
+29Welcome to the Airtable community!
The MAX and MIN functions are a bit tricky to use when working with dates. They do not work well with lookup fields, and lookup fields also tend to be tricky to use in formulas.
Instead of using a new formula field based on the lookup field, try creating a new rollup field with the same linked field as the lookup field, and use the formula
MAX(values)
Welcome to the Airtable community!
The MAX and MIN functions are a bit tricky to use when working with dates. They do not work well with lookup fields, and lookup fields also tend to be tricky to use in formulas.
Instead of using a new formula field based on the lookup field, try creating a new rollup field with the same linked field as the lookup field, and use the formula
MAX(values)
Thank you Kuovonne, that was exactly my need!
Now I have to understand difference between Rollup and Lookup :slightly_smiling_face:
Have a good day
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
