Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

MAX(values) in rollup not working when nested in IF function

Topic Labels: Formulas
193 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone, :wave:

I’m having some odd behaviour I can’t figure out.

I have a formula rolling up invoices linked to a case.

IF(Statut = "Clos et facturé",MAX(values),"Dossier ouvert")

It does not work.
The cell shows up empty when it should show the last invoice date.

But if I try:

MAX(values)

It works.

And if I try:

IF(Statut = "Clos et facturé","test","Dossier ouvert")

It works too.

I’m puzzled as to why my first formula does not work.

Thank you for your help,
Joachim

1 Reply 1

You’re always going to run into trouble when mixing numbers or dates with string values.

If you want a field to show both dates and strings, you need to convert your dates into strings using DATETIME_FORMAT(). This also may require you to use both the Rollup field and a Formula field if doing everything within the Rollup still doesn’t work.