find the smallest value based on contact name and date

i'm looking to a formula or any way to find the smallest number un a column based on contact name and date. the numbers refer to hours (800 = 08:00, 1500 = 15:00)

the goal is to get the first task of each day for each name.

here is a daft table of the basic column used:

in yellow are the value the formula has to find.

thank you for your help

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @Julien Lopez,

Try this formula.

=IF(Time@row = MIN(COLLECT(Time:Time, Name:Name, @cell = Name@row , Date:Date, @cell = Date@row )), Task@row )

This will flag show the first task in the corresponding row. Here is what it looks like.

Hope this helps,

Dave

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.