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.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
