Min value of two columns

[J_jvs]

How can i translate to appsheet expression this formula?
=MINIFS(E$1:$E2;A$1:$A2;A2;B$1:$B2;B2))

where A=name and B=date

thks for your help

[Aleksi]

You would need to use a SELECT expression with the AND condition… like MIN(SELECT(Table[Column],AND(…))). Please check this article

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[J_jvs]

thks Aleksi,
im using:
=Min(SELECT(dades[hora], [id] = dades[_this].[id]))
I created a new column: [id] = concatenate of name and date.

but in the first entries (by user and date) not get/appears inital hour ([horaInici]

[Aleksi]

Would you please describe your request using this sheet.

[J_jvs]

Hi Aleksi, this image is ok for you ?

in orange = These cells have not acquired any information.
in yellow = F3 use information from D2 not from D3.

[Aleksi]

You should probably use MIN(SELECT(dades[hora],[ID]=[_THISROW].[ID]))

[J_jvs]

not always runs!
when i start database it not find any min value

[Aleksi]

Yes that’s true if you use normal column. With the virtual column it should find it.

[J_jvs]

yes Aleski, i only need:
min(SELECT(dades[hora],[id]=[_thisrow].[id]))

max is not necessary for my app.

thks a lot for your help!!!

[J_jvs]

Sorry again Aleksi, but i used a virtual column and it not runs properly, the expression “max(SELECT(dades[totalHoresFinsAra],[id]=[_thisrow].[id]))” not get last value entered , it use the penultimate value.

[Aleksi]

You’re welcome