Hi all, I am trying to find the latest status of a project using Arrayformula… Gsheet structure : [Project] tab with all my ongoing projects (name {in column A}, launch date, comments…) [Status] tab which tracks the successive status of each project (project name {in column D}, status, date …

@ionamol Doesn’t array contraint get thrown off if you have empty rows? I thought I read somewhere that empty rows caused issues, but maybe it had to do with the type of formula used inside of it. I’ve never used it, but I’ll have to play around with it sometime. @Clement I tried what you mention…

Anyone knows how to retrieve the latest entry of an item?

Ask for Help

Jeff_Hager January 29, 2020, 4:13pm 2

Don’t ask how it works. I just know it works.

3 Likes

Topic		Replies	Views
Display the latest item from my sheet Ask for Help	9	718	October 13, 2019
Updating Sheet column from Formula Column Ask for Help	10	523	January 17, 2024
Google Sheets and ARRAYFORMULA Ask for Help	22	1427	July 13, 2023
[Video Tutorial] Always show the last 4 items in your home screen Ask for Help	5	642	March 24, 2020
Looking for an ARRAYFORMULA Ask for Help	12	930	June 4, 2020

Anyone knows how to retrieve the latest entry of an item?

Related Topics