Are you using a form to submit the status? You can now use actions on form submit to write to a column (set columns) in a related sheet through a single relation.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Updating Sheet column from Formula Column | 10 | 619 | January 17, 2024 | |
| Update column with new form submission | 2 | 344 | August 12, 2020 | |
| Updating values in related table | 8 | 853 | January 10, 2022 | |
| Update Sheet A when Submit Form B | 6 | 304 | July 7, 2020 | |
| Set Columns Action | 12 | 2289 | January 17, 2024 |