Link to specific cell only
In Excel you would place a $ ahead of the row / column to point to a cell that should not change. I have the following formula; =IF(PHASE@row = "YES", [Task Name]@row, 0)
I do not want the primary Task Name to change.
What do I need to do to modify this formula?
Help Article Resources
Check out the Formula Handbook template!