Hi everyone,
I need help on the following topic. I am trying to create a formula to show (measure) the running time in days between the column "done" and the column "creation date"?
(see attached image).
Thanks for your feedback
The cell history can not be accessed from the GUI.
You will need to use the API for this. I think some of the automation tools MAY expose this, but I don't think it is intentional and therefore the API may be the only way to do this.
Craig
--Update--
This post triggered a new thought on Zapier:
https://community.smartsheet.com/discussion/capture-start-time-and-finish-time-form
This discussion was created from comments split from: Licenses and True-up confusion.
Our users are noting that a specific column is not submitting the data they selected correctly. It is a dropdown column where you can only single select from the list. When checking the cell history, it is showing one entry for the incorrect item. While we aren't ruling out continuous user error, we have seen enough…
I created a new project in my PMO, when I tried to pick a contact there were very few listed 7 versus the 165 people in my org. I checked My Contacts and all of the contacts were listed. Do I need to link that somehow to my sheet? How would I do that? Second question, what is the best strategy to keep My Contacts updated…