Formula Error

System

This discussion was created from comments split from: #INCORRECT ARGUMENT SET.

Cesar_Rodriguez

@Brian_Richardson could you please advise me about this error?

the formula is the following:

=TODAY() - MAX(IF([Last Service Data GMM]@row, ="", 0, [Last Service Data GMM]@row), IF([Last Service Data MMM]@row, ="", 0, [Last Service Data MMM]@row)) I´ve tried all but is still showing the #incorrect argument set. I hope that you can help me.

Thanks

Brian_Richardson

@Cesar_Rodriguez your formula column needs to be a Date column, you are taking a date (TODAY) and subtracting a number of days from it, which returns a Date.

It looks like you have probably a text/number column which gives you the error #INVALID COLUMN VALUE. If you put the formula into a date column you'll be fine, I tested it as you typed it and it works just fine:

=TODAY() - MAX(IF([Last Service Data GMM]@row = "", 0, [Last Service Data GMM]@row), IF([Last Service Data MMM]@row = "", 0, [Last Service Data MMM]@row))

Cesar_Rodriguez

hello Brian, I´ve tried and didn´t work, actually the error message is  #incorrect argument set. You are correct the column is a text column and it does work with the other rows, in the one that doesn´t work is where I have a blank cell in both places, that´s the reason why I´m trying to use IF.

Do you have any other idea? Thank you so much!