Sign in to join the conversation:
I have seen several forums related to Time of Day as a column option. This appears to be ongoing for nearly (4) years as a feature enhancement. Can someone provide an update and a simple workaround (not a long-winded formula option)?
I have not seen any proof that it will be a feature enhancement. It has been requested as one. You can submit a product enhancement request for this but it doesn't guarantee the item will be added to smartsheets. Every vote counts.
What do you mean by a work around? Are you looking to be able to calculate time differences, or are you looking for more of a time stamp kind of thing?
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
