Best Of

The formula in the helper column would be:

=PARENT(userName@row)

It will have to be present in every row. If you are worried about keeping the sheet clean, you can use a helper column to pull the user name into every row based on the parent cell, hide the column, then reference this helper column in your MAX/COLLECT.

You need a MAX/COLLECT combo instead of those IFs.

=MAX(COLLECT({Date Column}, {User Column}, @cell = userName@row))

Hi @TorAtle Myrmel,

If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:

=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])

Example:

Hope this helps, but if you've any questions or comments then just post! 😊

Hi,

I hope you're well and safe!

Try something like this.

=IF([COMMODITY CODE]@row<>"", LEFT([COMMODITY CODE]@row, FIND("*", [COMMODITY CODE]@row) - 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Hi @Marcin4q

I hope you're well and safe!

This is a perfect use case for the Premium App, Data Shuttle.

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

The challenge with VLOOKUP is it specifies a column number. If you change the column order or add a column to the reference sheet, it could throw off your formula and return incorrect information.