Versions Compared

Old Version 1

changes.mady.by.user Jaramy Conners

Saved on

compared with

New Version Current

changes.mady.by.user Jaramy Conners

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When using a formula, you can assign a variable to reference another column in the structure, including another formula column.

To assign a variable to another column, look for the USED IN COLUMNS section in the Source drop-down.Mapping a variable to another column in the formula editImage Removed

...

Warning

The Used in Column attribute copies the existing column. It does not link to that column. This means:

  • You can remove the original column without affecting your new formula. The calculations will continue to work just as they did at the moment you first configured the variable.

  • If you update the original column and want that update reflected in your new column, you need to

    reassign the variable.

Example

In the example above, we created a variable to track the results from the Epics Under/Over Time formula we created in our Formula Column article. If the original formula resulted in a negative value, this column will list a simple "WARNING" text flag.

Image Removed

Once we've created our new formula column, if we make changes to the original Epic Under/Over Time column - or even delete it - our Epic Time Warning column will be unaffected. It will still give us a warning whenever we've spent too much time on a particular epic, because the new column (Epic Time Warning) continues to do all the calculations the original column did, even though the original column has changed.

...

  • remap the variable.