How to track preivious months status

Kaveri Vipat

Hello Everyone,

I wanted to track the Status of the Project. I have one-sheets in which all the projects are listed and the leads are updating the status through the RGBY symbol column for example, on 1st Oct the status is Yellow, on 1st Nov it is updated to Red, so on 1st Dec, I want to see the status of Oct and Nov in different columns, please see the below screenshot for reference.

Please suggest some way to achieve this, I am not using any formula for calculations.

Thanks in advance!

Andrée Starå

Hi @Kaveri Vipat

I hope you're well and safe!

Please have a look at my post below with a method I developed. (could be modified to work for your need)

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Kaveri Vipat

I hope you're well and safe!

Please have a look at my post below with a method I developed. (could be modified to work for your need)

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kaveri Vipat

Hi Andrée Starå,

Thank you so much for your help! , it worked for me, now I want to calculate the dates for 6 weeks, or 1st of this month and the 15th of next month for some calculations.