Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Help with formula for line chart?

image.png

Right now I have a formula set up to count hours for each week given certain criteria.

image.png

The count from each week is then added to the past week to get an ascending total each week to display in a line graph for a running total. How can I write this formula to count when it is the current work week only so that the chart line doesn't track across to wk52 from the current week and It doesn't have to be updated manually?

image.png

Thanks

Matt

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions