Forum Discussion
Pulling data fields from reports (based on date) and compiling them into another tab.
Hello,
instead of an IF command i've tried this formula
=IFERROR(INDEX(CoverPage!$I$51:$I$53,MATCH([@Ring],CoverPage!$C$51:$C$53,0)),"")
in cell B3 of sheet "Compiled Info" and it seems to return the expected result. The formula is spilled down within the dynamic table. However because of the merged cells in sheet "CoverPage" i find it difficult to help with this task.
I have been playing around with this and actually for one field working on the compiled tab by using this formula - =IF('CoverPage'!$C$51=[@Ring],'CoverPage'!MuckWeight,"")
But the issue is that when the ring number on the cover page changes, it just disappears from the compiled tab. how can I get these to stay as a record? See my updated file attached please. Also, thank you both so much for the help with this!
- Patrick2788 OliverScheurich Can either of you help me out with this?
Hello,
instead of an IF command i've tried this formula
=IFERROR(INDEX(CoverPage!$I$51:$I$53,MATCH([@Ring],CoverPage!$C$51:$C$53,0)),"")
in cell B3 of sheet "Compiled Info" and it seems to return the expected result. The formula is spilled down within the dynamic table. However because of the merged cells in sheet "CoverPage" i find it difficult to help with this task.
- I put that formula for a few fields and it populates on the combined tab. The only issue is that it does not save it there. When I delete the info, it deletes from the combined tab. This report is going to be held on sharepoint and edited by multiple people. so when the next shift comes in, they will edit the cover page and put in their own info. The result that I really need is that when they delete off of the cover page, it is still recorded on the combined tab. There will never be duplicated rings, so once a ring # is recorded, it will not need to change. Is there any way of doing this?