Tracking Prev Wk % Complete to Current Wk % Complete in Sheet Summary fields


I'm newer to Smartsheet and trying to figure out what formulas I would enter into two Sheet Summary fields in my project plan to track 1) The previous week's overall project % complete (e.g, 45% complete as of X date) and 2) the current week % complete (e.g, 48% complete as of right now). It would also be great if I could figure out a third Summary field function that would show the variance (e.g, perhaps a symbol like a green up arrow showing 3% [increase difference from 45% to 48%] or a horizontal line showing 0% if no % increase from prev week). I'm looking for these fields so that I can pull them in on a weekly status dashboard report. Thank you in advance for the assistance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!