#INVALID DATA TYPE in Rankeq function
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?
Best Answer
-
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
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Answers
-
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
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!