Is there an automation/formula that allows a copied row to be updated?
I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the info for their institution. There is a row for invoice status on the master sheet that can be manually updated to "received, submitted for payment, paid" depending on where that invoice is in the process. I'm trying to have the copied row update in the separate sheet when I update the row in the master sheet. Is that possible?