#INVALID DATA TYPE in Rankeq function

Prasad Nimmagadda

Following function flags #INVALID data type error.

=RANKEQ([Row No]@row, COLLECT([Row No]:[Row No], [Project Name]:[Project Name], [Project Name]@row), 1)

Column [Row No] type is Text/Number

COLLECT function is getting executed properly. I have debugged it separately. It is collecting the values of [Row No] column.

Will anyone able to suggest what is the issue?

Michelle Choate 2

I just did the exact same formula with the same column names and it worked perfectly for me. My Project Name column is Text/Number and my Row No column is # auto-number. I even switched it to text/number and it still worked perfectly.

Try refreshing your browser. If that is still not working, can you post a photo of what is happening?

Michelle Choate 2

I just did the exact same formula with the same column names and it worked perfectly for me. My Project Name column is Text/Number and my Row No column is # auto-number. I even switched it to text/number and it still worked perfectly.

Try refreshing your browser. If that is still not working, can you post a photo of what is happening?

Prasad Nimmagadda

Michelle,

First thanks for taking time to test the code. Row No supposed to be #Auto number. As I was getting #INVALID DATA TYPE, I have changed it to Text/Number type. Even after that I was getting same error. I am really puzzled about it. I will check clearing the browser. Let you know what happened.