Automate SLA Column if conditions are met (for Item, Package Type & Supply Materials column)
Hello.
Need help on this. I need to automate the SLA column on Draft OSM tracker Sheet in reference to another sheet (2019 Revised Standard..). the SLA column must show the value if Item, Package Type & Supply of Materials columns are filled in.
Thank you.
Best Answer
-
You are going to want an INDEX/COLLECT for this one.
=INDEX(COLLECT({Source Sheet Lead Time}, {Source Sheet Item}, Item@row, {Source Sheet Package Type}, [Package Type]@row, {Source Sheet Supply}, [Supply of Materials]@row), 1)
Answers
-
You are going to want an INDEX/COLLECT for this one.
=INDEX(COLLECT({Source Sheet Lead Time}, {Source Sheet Item}, Item@row, {Source Sheet Package Type}, [Package Type]@row, {Source Sheet Supply}, [Supply of Materials]@row), 1)
-
Thank you @Paul Newcome!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives