Sign in to join the conversation:
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
Hi Andrew,
Unfortunately, it's not possible at the moment because Smartsheet doesn't have a time function, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
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
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
I need a formula that looks for the a specific person in the Ball In Court column, then look at specific status in the Comment Status column and then look at another column and if it is blank return the number. I am not sure on what this should look like for the last column.
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…