Sign in to join the conversation:
I am wanting to create a formula whereas I have an expected delivery time and actual delivery time and need to determine how many minutes the delivery was late. Does anyone know what formula to use in Smartsheet?
Smartsheet currently is unable to calculate time. However, depending on your setup and overall requirements, some basic formulas in helper columns can be used.
Â
Will the expected and actual times overlap into another day? Do you want it displayed in just minutes? What format are you using for time (12 or 24 hour clock/colon or no colon/am vs pm/etc..)? Are you able to post some screenshots with dummy data manually entered to show what you want the final solution to display?
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
