5 nested IF arguments
=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
Best Answer
-
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.
Answers
-
Double check that [#3 Date of Review] is set as a date type column and houses date type data.
-
The data type column is the same.. it works perfectly for the 1st two arguments
-
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?
-
=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"))))
-
What about the column properties for [#3 Date of Review"? How exactly are the dates populated?
-
The column properties of the [#3 Date of Review]. The date is added when they have a new review.
-
How is the [Latest Review Date] column being populated? It looks like a column formula. What is the formula?
-
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
-
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.
-
YOU ARE A LIFE SAVER!!! JUST BECAUSE OF A PARENTHESIS! THANK YOU SO MUCH!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!