Convert Formula to Plain Cell Value

Options

Hi there!

For this question, I have my formula figured out. Basically, I need PMs to enter a value into a cell on a weekly basis and have that value recorded for historical record. I have that piece working, using an if statement based on the week number.

I'm just having issues getting the actual history part to work. Because I'm using IF statements, when the sheet rolls to a new week, the previous data obviously gets overwritten, so I need to convert the result to a plain value. Any way to do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!