Welcome!

Time

Hi all

Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes/secs(don't mind either) from a system column

also is there an hour or minute function in Smartsheet?

thanks in advance

Formulas

Hi Andrew,

Unfortunately, it's not possible at the moment because Smartsheet doesn't have a time function, but it's a great idea!

I know that the Smartsheet team is hard at work on a time function.

In the meantime, there are some different workarounds.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Date minus # of days to get new date
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
What is the best practice for referencing data in another sheet?
I currently have a Data Shuttle updating/replacing all cells in sheet 1. In a second sheet I have a formula that performs an Index/Match with the result coming from that first sheet. I noticed the cell history on the second sheet is capturing the first sheet values disappear and then come back in (example below). Assuming…