How can I display a date range based on week/month numbers?

Joshua Fargason
edited 12/09/19 in Formulas and Functions


Here's the situation:

I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals.  At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc. because I do not know if it's possible to code a cell to turn out a date range based on a week number or a month name based on a month number.  

Is this possible?  How would I code that in?


Graphs example.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!