i have a spreasheet to track completion status on Jobs. i am using the following formula to return a value based on employee input in the previous cell as "started" or "complete": =IF(B2="complete",TODAY(),IF(B2="started","In Process","")) my problem is each day the completion date changes. is there another function to lock in the date that the data was entered?