One Approval for Multiple Lines/Whole Sheet
I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column that has checkboxes for approve, deny, etc.
My concern with this way is that, in case the report have 200 lines, the approver will have to go through every line and check 200 boxes which is not so efficient.
Is there any other workaround that allows the approver to check one box only and it will automatically apply for the rest? Think about the paper report that only needs one signature from the manager for the approval.
My thought for now is to create an approval sheet in which one line represents its connected report/sheet and the approver will check the box there after he reviewed the report/sheet. Then use formula to indicate the status in the status column in the original sheet.
Thanks in advance for any help/comment!