Auto-Number the next column within one row

Philip.Rutherford.23

Hello,

I have created a sheet that I will use to track scheduling in Construction. I have attached 2 photos. I want to have an automated number/date system like the excel picture shows. Can anyone assist in what formula or strategy I need to implement?

Thank You

Paul Newcome

Where are your dates? Have you looked into Gantt view?

Philip.Rutherford.23

I have but my dates will change regularly. To provide more insight, this is something that I will be saving as a pdf to send out on a weekly basis and the numbers in the top row will change each week to reflect the day of the month. For instance, I have attached a screen snip of what I would like to be automated. I achieved this by setting M1 as the 7th and went to each individual cell and did =m1+1 and so on. Next week when I do it, it will start with 14 and continue from there. I can change it every week but would like to save myself some time and learn a new trick if possible. One of the snags with my system is when I get to the end of the month and need to start at 1.

Philip.Rutherford.23

Paul Newcome

Nov 11, 2022

Where are your dates? Have you looked into Gantt view?

See other comment

Paul Newcome

What determines which cells get highlighted?

Philip.Rutherford.23

https://community.smartsheet.com/discussion/comment/350965#Comment_350965

That is only to differentiate the weeks. I am only concerned about the numbers

Paul Newcome

Do you have a starting date (similar to your excel screenshot), or is it some kind of logic based on today's date such as first column is always current Monday? If it is "current Monday", how do you handle if today is a Saturday or Sunday? Would you want it to show the previous Monday or the upcoming Monday?