Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

formula in linked cell?

Options
IFCC
IFCC ✭
edited 12/09/19 in Archived 2017 Posts

I have a "Master" sheet with incremental rows in groups of 16.

So  Task Name column has Row1toRow16, Row17to33 with the same headings.(SEE PIC 1)

I pull info out of this sheet to other sheets.

So on another sheet I just want Row1,Row17,Row34 etc entered in. (SEE PIC 2)

I have the first one linked to Row1 "Master". Is there a way to use a formula and drag down

that might look like  =Master[Task Name]1 + 16

pic1.JPG

pic2.JPG

· Share on FacebookShare on Twitter

Comments

This discussion has been closed.

Categories