u/Similar_Touch_6783

I bought a new phone on Friday and went to pride on Sunday and guess what! It got pickpocketed!!! I’m so pissed out of my mind and there’s no support from Fido (or the police for that matter). I’ve called 611 they scheduled me for a call on FRIDAY LIKE WHAT??

I’m trying to accept the fact that I still have to pay the phone since I was still debating on buying insurance or not but I’m just so… so pissed and tired.

What are the chances that Fido takes pity on me? If anyone has gone through anything like this, some anecdotes would be nice :(

Hi! As the title says I don't know how to refer to a dropdown list I've made on Google Sheets on my AppScript code.

For reference, I'm working on a Form entry pop-up that I want to also ask the user choose from a dropdown list, afterwards, it should append the data in a new row on a Google Sheets tab.

I've attached my html and gs code and google sheets screenshots.

html code for popup

gs code

where i want the data to be recorded

Hi! I've been working on a calendar with a task entry tab (2nd img) where i can choose from a dropdown that allows multiple choice. Depending on the month, it'll appear on a monthly calendar and add the task to a monthly task log. This second tab (1st img) also lets me filter it based on the "PIC" dropdown.

My problem is that when doing multiple choices, it won't consider it and therefore making tasks assigned to multiple PIC invisible. The code i have on the calendar is the following:

=IF(ISDATE(B5),IFERROR("- "&JOIN(CHAR(10)&"- ", FILTER('Task Entry'!$D$4:$D, 'Task Entry'!$F$4:$F=B5,'Task Entry'!$G$4:$G=F2)),),)

on the FILTER(task title, cond1=date is the same as in the task entry tab, cond2=PIC matches department choice)

Please help and ty!

https://preview.redd.it/53946d6ivq7h1.png?width=2862&format=png&auto=webp&s=ec6858803876e6abe5931c5606dc3a8a1262b96e

https://preview.redd.it/cw38ws80vq7h1.png?width=2488&format=png&auto=webp&s=3669f7b4976c4f00da2ad47efd78278f0626006d