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 am looking for your help once again :) So the below formula works fine for me however I have other sheets that I also need to reference. I'm assuming I would need to add an AND or OR formula to the below however I'm not sure where or what structure the formula should be. And its to reference another 4 sheets, including…
Hi There, I'd like to count the cells which year belongs to 2024, seems the formula I wrote cannot capture the correct volume, may I seek your help for it? which part is wrong in my formula? Details as following: My formula: Reference column: Thanks in advance!
I wanted to join the text(PM names,ID) in two or more cells which is basically multivalue cells and display the same one below other and also i want the duplicate names also to be displayed
