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 | 9 | 623 | January 5, 2021 | |
| Update column with new form submission | 2 | 345 | August 12, 2020 | |
| Updating values in related table | 7 | 858 | January 9, 2022 | |
| Update Sheet A when Submit Form B | 6 | 305 | July 7, 2020 | |
| Set Columns Action | 11 | 2294 | March 8, 2021 |