Is there a way to reference the row above?

2»

Answers

  • I'm just asking for an example of a value in a previous row being referenced in a current row formula. Can we focus on that?

    How about an If statement? If something is true, I want to return the value of the previous row, else something from two rows above it?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!