I have created a sheet where all of our projects are stored. The sheet is filled by a form where you can insert the details. After submitting the form an approval process starts where the teams can approve or decline as well as they can add a comment.
My question is about these comments. Is there any way to automatically extract the comments and show them in cells? I have a dashboard where you can see all new projects. This view (with new projects) is based on a report.
It would be great if I can show these comments automatically in the dashboard. Maybe also "live" (as the comments are incoming over several days).
I already have searched the community but just found solutions like "manually copying the comments to a cell" which would not be my favorite. :)
Does anyone know a workflow to achieve something like that?
Thanks for your help and best regards