Jim Hook’s Profile

Community member since April 2015

Breyta Inc.
Area of expertise
Web Forms
How I Use Smartsheet
I provide project timekeeping and financial analysis for a small company with Fortune 500 clients located mainly in the US and Europe. With Smartsheet I keep realtime track of the 40+ projects underway at any point in time and provide feedback to managers and supervisors that continually helps them to improve estimating and project execution processes.
About Me
With a background in electronics, computer science and semiconductor testing I missed the technical involvement after 11 years of retirement and ended up helping out at Breyta in a number of roles as the company has grown quickly over the last three years.


I am trying to calculate Percentage Complete on a task (Project). I know the Percentage Left (that calculation is working perfect), but the Percentage Complete works on one sheet and not another. 

=SUM(1 - [Percentage Left]4)

On the next sheet I try the same thing and all I get is the return of the


Hi: I am looking to see if the software is able to time stamp an item to keep a record of it. we would like to have a checklist and once a task is completed or changed. if there can be a timestamp on day/time in order to keep records for auditing purposes. 


is there such a thing? 

thank you.