Text and drop down

[meenank]

I'm trying to make an app to record patient data upon hospital visit (eye) 

I'm stuck in 2 places 

1) I want to add text 'clock hrs' to number selected.. 

This is the extent of lesions which is spoken in clock hrs

Like if I selected 1 the outcome should be 1 clock hrs. 

2) for patients review when I select

 1 week outcome should be today + 7

2 week = today+14

So on.. 

Thank you for replying

Hope this helps in understanding what I am trying to achieve

[Marc_Dillon]

---

@meenank wrote:

1) I want to add text 'clock hrs' to number selected.. 

---

In another column, concatenate the number selected with the text "clock hrs"

---

@meenank wrote:

2) for patients review when I select

 1 week outcome should be today + 7

2 week = today+14

---

You could setup a large IFS() expression, like TODAY() + IFS( [x]="1 week" , 7 , .....)

Or you could SPLIT() on the space character, and take the 1st INDEX() and convert it to a number and multiply by 7.