Hi all
Hope you can help me.
i'm trying to make a formular that can help me check off the checkbox in another sheet.
So its going to be somekind of formular that looks into another cell and if it is checked off it is going to checkoff in that sheet as well.
So 1. sheet is the Intake sheet. - The 2. sheet is the tasklist.
The orders come though to the intake sheet and then they are copied (automatic copy) into a tasklist. When the task is finished the status will be changed to done and it auto checkoff the "Done" checkbox column. So instead of manually going into the intake sheet and checking this one off too, I want it to recognize when the tasklist is checked off so will the task in the intake sheet.
right now i have been working with this:
=IFERROR(INDEX(COLLECT({Tasklist DK Range 3};{Tasklist DK Range 5};[project number]@row);1),"")
- It doesn't work it comes back with #unparesable
Hope you can see the solution!
Best!