How to link value with time slots?

Hi y'all,

For work, I have to make an idea- & to-do list. Short description: someone has to fill in a concept, the date of entry, and priority: high, medium, low. Based on the priority, we want to give it a timeslot so we can take it into a meeting.

We would like to give the values:

High = 48 hrs
Medium = 7 days
Low = 14 days

E.g. employee A filled in a concept on 21-01-2021 with high priority. Therefore, we want it in our agenda sheet with the date: 23-01-2021.

Which formula should I use?

It would help if you attached a sample Excel workbook. See the yellow banner at the top of the screen for details of how to do this.

Pete

Hi Pete,

Thanks for the quick reply. I have attached a sample Excel workbook. I'm still struggling since the last post. I'm using the IFS-function, but without success.

You can change the second part of your formula to this:

VLOOKUP($D2,{"Low",30;"Medium",14;"High",2},2,0)

So your formula in P3 would be:

=IF($E2="Yes",$K2+VLOOKUP($D2,{"Low",30;"Medium",14;"High",2},2,0),"")

You might need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Hope this helps.

Pete

Hi Pete,

Thanks again. I can see that I'm one step further to solve this case, however, I get the following error message when inputting the formula. If I use (,) or ( I'm getting the same message. Also attached is the excel sheet with the formula.

Schermafbeelding 2021-01-26 105638.png

Hope you can help!

Greets!

I've attached the file with my formula in it - see how that gets translated for you.

Hope this helps.

Pete

Hi Pete,

Formula: =IF($E2="Yes";$K2+VLOOKUP($D2;{"Low"\30;"Medium"\14;"High"\2};2;0);"") works!

Many thanks! I was struggling with this for a while now.

Kind regards,

Glad it worked for you, and thanks for marking the thread as Solved.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete