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	757	October 13, 2019
Updating Sheet column from Formula Column Ask for Help	10	581	January 17, 2024
Using an ARRAYFORMULA in Google Sheets Ask for Help	5	74	June 5, 2024
Google Sheets and ARRAYFORMULA Ask for Help	22	2538	July 13, 2023
[Video Tutorial] Always show the last 4 items in your home screen Ask for Help	5	672	March 24, 2020

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

Related topics