Hello community,
I need help figuring out how to set up a sheet to collect monthly comments on several projects.
Each project is assigned to a different person who need to provide monthly feedback on its progress.
Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if necessary.
I tried creating a sheet with a workflow that checks whether the “feedback” column is filled in or not to trigger the update request, but unless I create an additional column for each month in advance, I don't really see how this could work.
Is this really the only solution?
Or is there a way to automate the creation of columns for the coming months?
The final idea is also to have a readable dashboard so that feedbacks can be filtered by project and/or period, and I don't know if this is feasible with this concept of 1 month = 1 column.
If you have any ideas, please let me know! Thank you.
