I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out, is there a way to make this a rolling serial number as each update request is automatically sent?
A bit of background: I am using Smartsheet to track and notify suppliers of non-conforming material. Automation workflows are used to send out all pertinent line items that need a disposition response from the specific supplier. After dispositions are sent back via the update request, our company may be receiving a credit memo or RGA (Return Goods Authorization) to return this material. If I had a reference number tying back to the update request it would be much easier and quicker to tie the single Credit or RGA to multiple rows within our master sheet.
Help Article Resources
Check out the Formula Handbook template!