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.

Date/ Time cutoff tracking
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?