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

Topic Labels: Formulas
755 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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,

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.