Forum Discussion
Requesting formula to copy from one tab to another
Using OneDrive, I was successful in getting the formula to work dynamically. However, there are still some outliers to be fixed. Namely, it appears that the header in columns 4 and 5 on Sheet 2 are being truncated. I don't understand the formula enough to see why. There is also an error in 2.3.e, where I assumed missing information from Tab1. But that row has all the information being requested in the formula.
https://1drv.ms/x/s!AkS7DYdbFniAfr4R2wFMdjMegEQ?e=Qqx352
Hi jenniferk007 ,
We have already "chatted" with each other in your document. One problem is that Filter() can only return cells with a maximum of 255 characters. The truncation of the cell headers was a problem with the display and column width. I don't know if this is a specific Excel for Web problem. If you increase the column width, you can read your headings.
Otherwise, you have adapted the formula well to your table.
- I really appreciate your help!
- I must correct myself. It is not the FILTER that causes the problem with 255 characters, but the CHOICE function. If you make an "intelligent table" out of your table, you would no longer have the problem. If you want, I can create an example for you with your current values.
- UPDATE: Also, what is supposed to happen is when an "x" is entered into Column G on Tab1, the cell background color should change to red. Then each row should be added to the second Tab1 Action Plan tab.
