I have attached a snippet which is one of the use case to be implemented. I’m unable to write a logic to check the conditions in google sheet (where the assessment result is saved) by using 2 inputs from the user (email, topic selected from the dropdown using input dialog). i have written the logic to be used in red color in the snippet. please help me to proceed further.
rikulsilva
Anil_G
Nguyen_Van_Luong1
lrtetala
pere
AJ_Ask
Anirudh_Tugawe
Gokul_Jayakumar
Shiva_Nikhil
Shreesh_Bhardwaj