# Formula to fill cells automatically

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. ;-)

• ✭✭✭✭✭✭

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.

If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

• ✭✭✭✭✭✭

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.

If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

• ✭✭✭✭✭✭

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))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!