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.