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!
Hi, this column is a date column. I need to extract the day (like Thu) from it for each row. Could you please suggest a formula?
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
Hi, I have a sheet where i am trying to pull the weekday horizontally based on the dates.But I am unable to fix the formula.Can anyone suggest what formula to use
