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

Pull content from multiple rows into another sheet.
I have Timesheets and would like to create Invoices. Right now I have 2 sheets, Timesheets and Invoices. One person can have multiple timesheets for the month. Can I move cell contents from 3 Timesheets into one row on the Invoice? I have tried a Join/Collect but it is only capturing one row. Thanks!
IF Formula
I'm trying to set up a formula to calculate merit increases but, I keep getting "#UNPARSEABLE" in my cell. Can someone tell me what I am doing wrong? thank you! =if([Salary Per]@row ="Hourly",[Proposed Hourly Rate]@row *2080, if([Salary Per]@row ="Annually",[Current Salary Rate]@row *(1+[Increase Percentage Salary]@row…
INDEX or COLLECT with OR?
Pretty sure this a Friday afternoon brain lapse…. I need to pull a value over if one of two conditions is met. I need the {Request Number} from Sheet B IF [Case Number]@row matches {Case Number} on Sheet B OR IF [Person]@row matches {Person} from Sheet B. Thanks!1