INDEX COLLECT Formula Help

Good afternoon!

I have the following formula written to index collect a number from my master sheet and I am utilizing 2 sheets as references in the formula:

=INDEX(COLLECT({PSTrax SR #}, {PST Station #}, [ASSIGNED TO]@row, {PST Issue}, Issue@row, {PST Problem Type}, [Issue Helper]@row, {PSTrax Type Master}, TYPE@row, {PST Open Date}, >=DATE(2023, 1, 1), {PST Open Date}, <=DATE(2023, 2, 1))), 1)

It is coming back #UNPARSEABLE. I tried adding =IF([ASSIGN TO]@row, 1, to the front of the formula, but it only returns a 1. Help?

Thank you in advance!

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!