Copy and keep cell value based on day of the week.


Hello All,

Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed?

Backstory: I currently have a dashboard with graphs that illustrates a rolling 7-day, 30-day, 60-day, and 90-day account interactions. I would like to compare the current 7/30/60/90-day values to their previous 7/30/60/90-day values so that I can see if utilization has went up or down in their respected time frame. I have a sheet with a "Date" cell that I update every M-F, so my logic was to create a formula based on the day of the week (Every Monday) that would drive my trigger for the copy & paste need. I've tried =If(Contains("Monday" but Smartsheets has a default date format "5/8/20" that the "Contains(" function relays on even if you change the date format to match below. I've tried other formulas but can't seem to piece it together to get the result I need. Any assistance would be greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!