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

[Joachim_Brindea]

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

[Kamille_Parks]

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.