Alternate for MAXIFS function

AjS

I have a scenario where in my smartsheet I have data for timesheet numbers for 12 months with multiple rows for a single user, I just want to use the latest set of records for all months and if any month has empty cell, then I want to pick up the previous record which has data for that cell, Possible ?

In Image 1 I have multiple records for 1 user and this data is being populated by forms, of all here I want to have only latest records of all months

here is the final sheet I want the numbers, I did a sumifs and getting sum of all records from previous sheet, but I just want latest record of Monica which is 156 from 07/19/2024

request some quick help.

heyjay

Is this the one you tried?

=MAX(COLLECT({2024 Time Sheet Range 3}, {2024 Time Sheet Range 5}, Name@row))

I made an edit , you might have seen the one before that.

heyjay

=MAX(COLLECT({July},{Name},name@row))

You'll probably need to make column references for each month.

AjS

@heyjay

I tried this

=MAX(COLLECT(({2024 Time Sheet Range 3}), July1, {2024 Time Sheet Range 5}, Name@row))

here I tried range using the reference sheet for the month values

I am getting #INCORRECT ARGUMENT SET, what am i doing wrong here ?

AjS

@heyjay or anyone who can help ?

heyjay

=MAX(COLLECT({2024 Time Sheet Range 3}, {2024 Time Sheet Range 5}, Name@row))

You have an extra parenthesis around Range 3, and remove July1.

=MAX(COLLECT(({2024 Time Sheet Range 3}), July1, {2024 Time Sheet Range 5}, Name@row))

AjS

@heyjay

it now shows #INCORRECT ARGUMENT SET

heyjay

Is this the one you tried?

=MAX(COLLECT({2024 Time Sheet Range 3}, {2024 Time Sheet Range 5}, Name@row))

I made an edit , you might have seen the one before that.