Reference a specific Cell

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

Developer

Accepted answers

kat

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.

All comments

kat

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!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703