5 nested IF arguments

tarastephanie

=IF([#1 Date of Review]@row = [Latest Review Date]@row, [#1 Time]@row, IF([#2 Date of Review]@row = [Latest Review Date]@row, [#2 Time]@row, IF([#3 Date of Review]@row = [Latest Review Date]@row, [#3 Time]@row, IF([#4 Date of Review]@row = [Latest Review Date]@row, [#4 Time]@row), IF([#5 Date of Review]@row = [Latest Review Date]@row, [#5 Time]@row, "no review"))))

it only goes up to the 2nd IF statement, by 3rd..it shows #incorrect argument

what is wrong with my formula

Paul Newcome

I think I found it. You have a closing parenthesis after [#4 Time]@row that should be moved to the very end of the formula.

Paul Newcome

Double check that [#3 Date of Review] is set as a date type column and houses date type data.

tarastephanie

The data type column is the same.. it works perfectly for the 1st two arguments

Paul Newcome

Are you able to provide a screenshot of the formula open in a cell as if you are about to edit it as well as screenshots of the columns being referenced and their column properties? How exactly are each of the columns being populated?

tarastephanie

=IF([#1 Date of Review]@row = [Latest Review Date]@row, [#1 Time]@row, IF([#2 Date of Review]@row = [Latest Review Date]@row, [#2 Time]@row, IF([#3 Date of Review]@row = [Latest Review Date]@row, [#3 Time]@row, IF([#4 Date of Review]@row = [Latest Review Date]@row, [#4 Time]@row), IF([#5 Date of Review]@row = [Latest Review Date]@row, [#5 Time]@row, "0"))))

Paul Newcome

What about the column properties for [#3 Date of Review"? How exactly are the dates populated?

tarastephanie

The column properties of the [#3 Date of Review]. The date is added when they have a new review.

Paul Newcome

How is the [Latest Review Date] column being populated? It looks like a column formula. What is the formula?

tarastephanie

It shows the most latest review date between the 5 dates

=MAX([#1 Date of Review]@row, [#2 Date of Review]@row, [#3 Date of Review]@row, [#4 Date of Review]@row, [#5 Date of Review]@row)

it's also a date column

Paul Newcome

I think I found it. You have a closing parenthesis after [#4 Time]@row that should be moved to the very end of the formula.

tarastephanie

YOU ARE A LIFE SAVER!!! JUST BECAUSE OF A PARENTHESIS! THANK YOU SO MUCH!!!