Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally).
But with cell linking it links the entire column of cells and I only need it to link cells based on meeting certain criteria specified in another cell ( the quarter it is planned for)
Is there a way to link cells based on criteria? or another formula that could also accomplish this task?
Help Article Resources
Check out the Formula Handbook template!