#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

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭
    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

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭
    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

  • 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!