Index/Collect does not work with < symbol

Hi there,

I am using the INDEX COLLECT formulas to get a value if a number is between two ranges. The issue is that I'm getting an #INVALID VALUE error in the following formula:

=INDEX(COLLECT({TotalRiskFactor}, {RangeStart}, >=[Risk Score]@row, {RangeEnd}, <=[Risk Score]@row), 1)

The problem is with the "<" symbol in the second range.

Formula.png


Here are links to the test files. Any help with this issue will be appreciated.

Destination File:

Source File:


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!