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…

Don’t ask how it works. I just know it works. [image] Display the latest item from my sheet Ask for Help Yes, this formula returns the last item that matches a search value: =IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B…

[image] Jeff_Hager: Don’t ask how it works. I just know it works. I have lots of stuff like this that fall in this category.

Ok this one is really impressive and I think I won’t even try to understand it :sweat_smile: “Curiously”, it works perfectly :rofl: However, I need the formula to replicate automatically to any new line (meaning any new project in my app) which can be created thanks to a “form button” in my app. T…

Not sure if this helps or even does what you want, but it seems to be relevant here. In this app: https://ktle5.glideapp.io I have people fill out a form to change the version. at the bottom of the screen. In the Spreadsheet Tab Today - Q2 - has the formula - =index(Update!B:B,max(row(Update!B:B…

Thanks for the insight. I can’t copy thee app to check of the formula works, but I understand that you are able to duplicate the formula thanks to the form button?

I don’t know if I’m missing something but I think that what you need is the same formular I’m using in my Slide OS. =ARRAY_CONSTRAIN(ARRAYFORMULA(IF( B2:B = “”, “”, VLOOKUP(B2:B, photos!B2:C, 2, False))), 3650, 1) Array Constrain / Formula to replicated the Formula to every new column IF to check…

Hello @ionamol and thanks for the input! I’ll check if I can do something with Array_Constraint which I kind of forgot :sweat_smile: Vlookup can’t work for me as I have 2 criterion for my “lookup” : the project name and the latest date. Maybe I could use a sort formula in order to sort in “date de…

That would be awesome for me. I did not have the opportunity to test it so far. I will let you know if I succeed :slight_smile: Le ven. 31 janv. 2020 à 04:19, Jeff Hager via Glide Community glideapps@discoursemail.com a écrit :

:partying_face: it works ! It just required to switch the colums in order to have the “date” column between the “project ID” and the “satus” ones :wink: Many thanks for all your inputs :slightly_smiling_face:

It’s a good thing you found the Glide option, since it would be much quicker than a spreadsheet formula. That was gonna be my suggestion.

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.

Topic		Replies	Views
Display the latest item from my sheet Ask for Help	9	775	October 13, 2019
Updating Sheet column from Formula Column Ask for Help	9	623	January 5, 2021
Using an ARRAYFORMULA in Google Sheets Ask for Help	5	115	June 5, 2024
Data calculate in Data editor to Gsheets Ask for Help	10	1194	June 13, 2020
Time of last post/row by user Ask for Help	11	682	October 21, 2019

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

Related topics