Can I auto-populate a cell with available license numbers listed in another column, sheet or report
We share license numbers and they are issued manually now. The process is, we look at the required dates, usually about three weeks, then look to see which license numbers are not in use during those dates and manually assign it. We would like to automatically assign it with a number not in use during the required dates.
Help Article Resources
Check out the Formula Handbook template!