Formula to fill cells automatically

felixo

Hi Community
I am looking for a formula to fill the cells in row 7 (and following) with the dates from milestones 1,2,3 and 4 automatically.

Please note that I am a complete newbie when it comes to Smartsheet. ;-)
Many thanks in advance for your help!

Mark.poole

@felixo

Try this out for you and see how it works.

=IF(ISBLANK(Melilenstein@row),"", INDEX([Ende (datum)]@row, MATCH(Melilenstein@row, Lieferobjekt2:Lieferobjekt5, 0)))

You could make this simpler if you use parent rows.

also as I do not speak your Language please be sure to make adjustments as necessary for the syntax. If need be I can assist with the indenting to make parent and child rows if you would like.

Mark.poole

@felixo

Try this out for you and see how it works.

=IF(ISBLANK(Melilenstein@row),"", INDEX([Ende (datum)]@row, MATCH(Melilenstein@row, Lieferobjekt2:Lieferobjekt5, 0)))

You could make this simpler if you use parent rows.

also as I do not speak your Language please be sure to make adjustments as necessary for the syntax. If need be I can assist with the indenting to make parent and child rows if you would like.

Adam Murphy

You could use INDEX/MATCH to do this, something like =INDEX([Ende (Datum)]$2:[Ende (Datum)]$5, MATCH([Meilenstein]@row, [Lieferobjekt]$2:[Lieferobjekt]$5, 0))

felixo

Thank you very much for your help, Mark and Adam!