Generate reference after box ticking
Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me.
I have a supplier approval database with supplier info, several checkboxes for required docs, etc.
Also have an approval column, and then an approval reference column.
What i intend to do is, when i tick the "Approved" box, i want the spreadsheet to generate the approval reference number.