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

SUMIFS formula with 1 Vertical and 2 Horizontal Criteria & Crosssheet references
Smartsheet Community - I AM STUMPED!! I am trying to do a crosssheet SUMIFS formula with 1 Column and 2 Rows of Data. I need to sum across {Weeks 1 to 104} Column to match : {Helper Column} = Baseline@row Vertical Rows {Month} needs to match Month@row, and Row {Year} needs to match Year@row I have tried SUMIFS, JOIN,…
Countif - No Match
Cant figure out why this is not working. It comes back NO MATCH. I have changed it to true and to 1. Nothing works. HELP
Supervisor Based "Current User" Filtering in Reports
I’m hoping to get a second set of eyes from the community in case I’m missing something obvious or there’s a cleaner pattern I should be using. I’ve used ChatGPT to try and help me group/organize my situation coherently…. Because at this point I feel crazy… I’ve literally worked on this for hours. Environment •Smartsheet…