Share
Report
104I would like to achieve the following;
For each row in my Excel spreadsheet that meets condition e.g. Yes/No column equals Yes, I want a colleagues to be notified that further information is required from them (simple information like Date, Short text etc.) The colleague email is mentioned in the Excel spreadsheet. Once they provide this information I want it added to the Excel table, or if it is submitted to a different table then a way to correlate between source row and the information they provide.
I very nearly have what I want where I have been able to send a form to the colleague requesting the information, the only problem is the form submits information to different sheet and there is no way to know from the form information what their information correlates to in the master table, I could solve this if the form could be partly pre-filled, but I understand from other forum posts this is not possible.
Example below: ColleagueZ should be notified/emailed/assigned task etc, that they need to supply Date and Comments information for ID row 1. Then somehow populate the requested data into the table.
Example of Master Table
| ID | Colleague Contact | Supplier Name | Factory Name | Period | Yes/No | Date | Comments |
| 1 | ColleagueZ@email.com | Supplier A | Factory 1 | 2022/09 | Yes | ||
| 2 | ColleagueY@email.com | Supplier B | Factory 2 | 2022/08 | No |
I guess I could send link of file to colleague, but there is risk they enter information in wrong row, or screw up the table somehow.
Any suggestions on apps/functions I can use to facilitate what I need would be much appreciated.
All responses (
Answers (
