Formula help or advice if possible
Hi, i am hoping some can help or confirm if this is possible.
The background: We are capturing data from employees working at 400+ locations. this is being done by a form. the data captured on the form is then being pushed out to individual sheets using a cross sheet formual:
=INDEX({Employee Communications for Tupe Range 1}, MATCH([Site Name]@row, {Site worked at}, 0))
This works perfectly, however we have several employees that work on more than one site and we are able to capture this from the form. However the above formula only works by looking at the first site.( Range 1) Can i add to this formula to say look at sites 2, 3 and 4?
I suppose what i am asking is if Range 1 returns zero then can it look at another range?
if i haven't explained this very well i am more than happy to share my sheets with anyone that may be so kind as to help.
Thank you
Dave
Comments
-
Hi Dave,
Can you share the sheets with me and I'll take a look?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
Thank you for offering, i have shared the sheets with you.
Regards
Dave
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!