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!
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
Here is the formula I am trying and it's brining back #CIRCULAR REFERENCE =IF(AND([FPI Date]@row >= DATE({StartYr}, {StartMth}, {StartDy}), [Jan FPI]@row <= DATE({EndYr}, {EndMth}, {EndDay})), [eCOA_ID]@row , "")
I have two sheets that are capturing two different sets of data. Sheet 1 (Billable Mileage Log) is capturing projects that have been marked as needing mileage to be entered in a different platform. Sheet 2 is capturing mileage that's being entered via a Smartsheet form. On this sheet, I have two columns that have formulas.…
