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
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
