Hello,
I am creating a request and process management sheet for our training department. They get requested to develop different training materials for various teams. We need to have a form that other people can fill out and request any combination of different assets (presentations, audio, video, tests, quizzes, etc). The requests will also be for new development or updating existing items.
When those requests are submitted, we can have a different combination of assets listed. One may be audio only while another could say video, quiz while a third could be presentation, video, quiz. So, they could be creating all new assets or updating an existing one.
I created columns on my sheet for each of the assets. This formula works but it is omitting the document status part of new or update and I've not been successful at getting it incorporated=IF(CONTAINS("Announcement", [Assets needed]@row), "5", "0").
So, basically, for each asset column I need something like:
If document status = New training item and
if Assets needed contains "assent name here"
= # of hours
But, if document status = Update existing training and
if assets needed contains "asset name here"
= this # of hours
In the past, I've just done an index/match, but since we have to allow for a multiselect field, I'm not sure how to accomplish this.
Thanks in advance:
