Reference a specific Cell

[garretwalters12]

What formula can I use in order to populate the date cell for ID SC-208 to match the date for RI-401?

Date	ID
09/18/2018	RI-401
09/20/2018	RI-402
	SC-208

[kat · Accepted solution]

Hi @garretwalters12

For this use case specifically you could use the multi row formula to update the Date field:

if [ID] = 'SC-208'
    then [Row-1:Date]
    else [Date]
endif

 Hope this helps.

[danilang]

Hi @garretwalters12

What's your criteria for matching the date?  Do you want the first one in the list? The 1st one of the previous group(RI-xxx)?  Always the date for RI-401

@kat it's  [row-2:Date].  typo no doubt:)

Dan

[kat]

good catch @danilang!