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.
...
Warning |
---|
The Used in Column attribute copies the existing column. It does not link to that column. This means:
|
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.
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.
...
|