Snapshot of a cell value

Josh Osborn

Is there anyway to record what value is in one cell on one sheet into another cell on another sheet at a particular time and date.

I am trying to streamline my job and every afternoon I have to record values from a master sheet into a financials sheet, if I could enter a formula into the financials cell to pull the value it needs from a particular cell at a specific time on a specific date then I could skip this one job everyday.

Any ideas?

Heather Duff

Hi @Josh Osborn ,

Have you looked into the Copy Row automation? It would copy the whole row to the other sheet, but you could hide any unnecessary columns. Perhaps you could have it move to the financials sheet?

I just had to use this feature on a project I created, and I was happy with how well it works.

Best,

Heather

Andrée Starå

Hi @Josh Osborn

I misread the question!

I hope you're well and safe!

To add to Heather's excellent advice/answer.

Please have a look at my post below with a method I developed.

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Josh Osborn

hI @Heather Duff

While the Copy Row Automation is a great idea, however the financials sheet that we use cannot accommodate the pasted information due to specific information being in that sheet that doesn't exist in the master sheet.

I know that what I want to do is possible in Excel through the use of script and VBA coding, however Smartsheet doesn't have that functionality that I am aware of.

I was hoping to find a work around needing to code using the DATE/TIME formulas however they don't even work in Excel.

Andrée Starå

@Josh Osborn

Maybe I was correct! 😉

Take a look at my post above.

You could use that method to collect what you need specifically for the Finance sheet.

Make sense?

Would that work/help?