RANKEQ - #INVALID VALUE

=RANKEQ([YTD Revenue]@row, [YTD Revenue]:[YTD Revenue], 0)

Hello,

Can you throw some light. A similar equation is working fine in one of the sheets and this one is throwing an Invalid value error.

How do I fix it.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!