return the value from the row above when conditions are met

Where the level of the row is 1, I want to return the value from the tasks column, but where the level of the row is not 1 (ie: child row), i want to return the value from the cell directly above. This way the children and parent have the same value. I dont know how to reference the cell above….

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!