LinkedIn
Twitter
Hi!
I have some columns in worksheet “Leave” which are filled by users using Form. While another few columns (Status, Rejected Reasons, Approved By) are to be completed by the approvers. For the latter, I used LinktoForm for approver’s input, the form is created as a separate worksheet “For Approval”
My intention is to have an overview of all leave application and status in one “Leave” spreadsheet.
I tried to link “Leave” and “For Approval” using dereferencing, as shown in the screenshot. However, the columns in “Leave” are not populated when “For Approval” is updated.
Seek your advise please. Thank you
