Sign in to join the conversation:
I have a sheet with an auto Created date & time column AND a modified date & time column.
Is there a way to create a formula column that will show Modified Date Time (minus) Create Date Time?
There is, but... It is horribly painful. Calculating time is something Smartsheet is not currently capable of, but there are a few workarounds. Check out the thread linked below.
https://community.smartsheet.com/discussion/calculate-time-between-two-dates-days-hours-and-minutes
Paul - I see you're extremely savy when it comes to Smartsheet, especially with calculating time.
I have a sheet with an auto Created date & time column and I want to calculate the hours from the created time to "now". Is that possible?
THANKS!
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
Trying to find matching serial numbers, then use delivery date of the first entry to derive support date of 2nd entry. The below works for the initial entry but the Extension Order gets #Invalid Data Type error. Thank you in advance for your suggestions. =IF([Order Type]@row = "New HW", DATE(YEAR([Delivered Date]@row ) +…
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!
