Generate reference after box ticking

Jose da Silva
Jose da Silva ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all,

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.

Any suggestions?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!