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 | 618 | January 17, 2024 | |
| Update column with new form submission | 2 | 344 | August 12, 2020 | |
| Updating values in related table | 8 | 851 | January 10, 2022 | |
| Update Sheet A when Submit Form B | 6 | 304 | July 7, 2020 | |
| Set Columns Action | 12 | 2288 | January 17, 2024 |