Drag Down Predecessor Formula to change with rows?

Hello,

So I have created predecessor formulas but when I drag them down or copy and paste them to another set of rows down below they still refer to the first rows while I want them to refer to the new rows but in the same order.

For example,

If on row 6 I have the formula 5FF+6D, I want to be able to copy and paste it to row 19 and change the formula to 18FF+6D. Instead the formula is still 5FF+6D.

Does anybody know how to get around this issue?

Thanks

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Alejandra

Hello,

When you copy a cell, the value will not change when it's pasted. An alternative to copying and pasting is to use the drag-fill method. I would suggest applying a filter to the sheet so that only the rows requiring the same predecessor are visible and then drag filling the predecessor down the column.

If the rows don't have anything in common that you easily use as a criteria for your filter, I'd suggest creating a checkbox column and then creating a filter that will display only the rows where the checkbox column is checked (you could hide the column later).

If needed, more information on these topics can be found here:

Drag fill: https://help.smartsheet.com/articles/2477471-dragfill
Filter: https://help.smartsheet.com/articles/2478846-filter-basics

Sign in to join the conversation!

Quick Links

Trending discussions

Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…
Why does the parent task my % column show as a decimal value instead of a percentage?
Why does the parent task my % column show as a decimal value instead of a percentage? I checked the column and project settings, and they are identical to another smartsheet in which the values show up as a percentage.