Welcome!

Calculating time

Hello

Does anyone know if there is a way to calculate Time in smartsheet without using a 3rd party program?

Thank you.

Workspaces

Sheets

Formulas

Hi Kara,

Is this still an option on trial? I'd be interesting in trying this implementation if it's available.

Thanks

Matt

I am also very interested in this option while we’re doing the trial. Is it still available for enabling?

Let me know and thanks,

John

Kara, Can you share this formula? I'm interested to see if it works for my current situation.

Match / Sumifs formula
Hello! I am looking for a formula to match the entry in sheet 1 to the entry in a sheet 2, then sum a column in another sheet 2. Would a match or vlookup formula work best? 1 - Match Primary, Tower and Blade columns in sheet 1 to Site Name, Turbine Number and Blade Number Sheet 2 2) Return sum in Travel Hours column from…
Extracting Multiple Data from one cell into multiple cells - same row
I have a smartsheet where I'd like to extract data from the LIST ALL occupants column and place them into Occupant 1, Occupant 2, etc. out to 13. I have this working for columns 1 and 2, but then it repeats, even though I change the +# in increments of 1… and if there are no additional names, I'd like it to be blank.…
Calculating Totals
Hi all, Im trying to use a formula to calculate how man hours of different leave type an employee uses to add to a report and or dashboard. Any suggestions on how to make that happen?