Web Applications Asked by allison on February 23, 2021
I have a spreadsheet with SheetA and SheetB. I’m trying to pull into SheetA some of the columns of each row in SheetB where the date in Column I of SheetB is earlier than today.
This formula on a single row works:
=IF(SheetB!I2<=TODAY(),{SheetB!B2,SheetB!F2,SheetB!D2,...},"")
But if I try to make it an array formula and apply it to a range, it stops working. E.g.,:
=ARRAYFORMULA(IF(SheetB!I2:I10<=TODAY(),{SheetB!B2:B10,SheetB!F2:F10,SheetB!D2:D10,...},"")
The way it stops working is it seems to no longer care about the <=TODAY part and starts to pull in rows seemingly at random—rows where the cell value in ‘I’ is blank, where it’s a date greater than today, etc.
Any ideas what I’m doing wrong?
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP