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	761	October 13, 2019
Updating Sheet column from Formula Column Ask for Help	10	600	January 17, 2024
Time of last post/row by user Ask for Help	11	672	October 21, 2019
Data calculate in Data editor to Gsheets Ask for Help	10	1165	June 13, 2020
[Video Tutorial] Always show the last 4 items in your home screen Ask for Help	5	678	March 24, 2020

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

Related topics