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	758	October 13, 2019
Updating Sheet column from Formula Column Ask for Help	10	582	January 17, 2024
Using an ARRAYFORMULA in Google Sheets Ask for Help	5	80	June 5, 2024
Data calculate in Data editor to Gsheets Ask for Help	10	1157	June 13, 2020
Time of last post/row by user Ask for Help	11	664	October 21, 2019

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

Related topics