Sign in to join the conversation:
How can we calculate time between start date and finish date? I want to know by hour and minute format?
I built this a while back.... read comments for the formulas
https://app.smartsheet.com/b/publish?EQBCT=698fa97db2e848acbba1db03ca04667b
Thank you for sharing this but is there any automated format or formula to calculate time without manually entering by users?
Nothing built in at the moment.. I believe some use Zapier to grab a Modified Date and hard-code it into a cell every time something specific happens.
Ezra is correct!
Zapier is a great option for this scenario. Is that an option for you?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I tried using Zapier but how? Zapier wants me to buy timecap app as well.
Azuqua seems pretty promising but my company doesn't want it since they think it might compromise the security.
What do you mean with that Zapier wants you to buy timecap?
Azuqua was excellent, but they have been acquired, and it's being retired for external use.
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
