I know Smartsheet is "working" on time stamps, but I need a little help. I am trying to calculate 2 different time scenarios. First is from the time a work order is opened to the time its is dispatched. Second is the time from the open date to completed date.

You will see on my sheet, the "open


Can smartsheet auto-populate cells based on the above cells in a column like excel do?

When completing text cells the system doesn't indicate that text word is already above? This is useful not to duplicate like currently, excel can do it by default. 

Any idea if this is possible or can be enabled