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

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:


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,

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.

1 Like