INDEX, COLLECT, CONTAINS Formula help
Hi!
I have a formula that is working the way I want...
=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row), 1), "")
But when I add another condition, I get #INCORRECT ARGUMENT SET. This is the formula:
=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row, {LFH Location}, CONTAINS("Home", @cell)), 1), "")
Any ideas on what may be the problem?
Thanks!
Answers
-
The formula looks good. Can you click on the cell with it in, as if you were editing it, and take a screen shot?
-
Hi KPH,
Thanks for the response. I ended up making a helper column in the source sheet that showed LFH Analyst if Location contained "Home." There's always another way, correct? 😁
-
Glad you got what you needed :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!