#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!
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!
-
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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!