Automate data into a cell from another sheet if criteria is met, then remove that data from source
I have a predetermined list of voucher numbers for exams. When a student meets certain criteria I want a voucher number from the source sheet to generate on the student's row automatically. After that voucher number has been used, it will need to be deleted from the source sheet. The voucher numbers come from the vendor. The student has to be "Approved". The criteria also will be to match the student ID and the exam type. I have sheet A - student information, exam type requesting, manager approval. Sheet B - list of voucher numbers to distribute. There are several different exams and voucher numbers, that will also have to match the exam type.
Is this possible in Smartsheet? Thank you for any assistance!!
Voucher source sheet:
Help Article Resources
Check out the Formula Handbook template!