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!
This discussion was created from comments split from: Ready Status Solved - I hope this helps everyone.
I have attempted, several times, to follow the exact formula provided on AI so that I can assign new rows to random users. The AI formula showed: =IFERROR(INDEX({Team Sheet Names}, MATCH(MOD([Row ID]@row , MAX({Team Sheet Order})) + 1, {Team Sheet Order}, 0))) Following the directions and making the sheet reference, I…
Had a follow up question to my previous question located here. — I was using the original sheets, which I fixed with the solution from that thread, as a template. Today, I copied them over to essentially create the same system for a different LOB. I checked the box that updated all formulas to the new references. Now, in…
