Cell History Data

Susan Swisher

I use Cell History to capture Budget Spend (for a project); is there a way to export or report on that History/Data?

Paul Newcome

You could look through/filter the activity log and have it exported.

Susan Swisher

@Paul Newcome I tried that; it wasn't as smooth as I thought and I couldn't weed out all of the data I wanted (quickly); I also noticed that I could only pull 90 days of data.

Paul Newcome

You should be able to adjust the dates in the filter when viewing the Activity Log.

Unfortunately referencing cell history is either manual or through the API.

Susan Swisher

@Paul Newcome I saw others mention "through the API" .. what exactly does that mean? I looked for plug ins or other options, and couldn't find a good solutions, either.

All of your help--very much appreciated!

Andrée Starå

Hi @Susan Swisher

I hope you're well and safe!

To add to Paul's excellent advice/answer.

Another option could be to save the history to another sheet using a Workflow that copies the row when it changes or similar.

Make sense?

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!