What is wrong with this formula?

Options

I keep getting invalid value. Can someone assist?


=INDEX(COLLECT({Last Name First1}, {Sector}, [Last Name, First Name]@row), 1)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!