great content Gareth! Been learning from you about airtable just due to personal curiousity. However, now that I own a small company, I follow you closer to implement solutions. Thanks to you, I'm moving over to SmartSuite, which I believe is a better overall solution, to actually build a system. thanks a lot sincerely for the great content I have a use case for the content in this video as well. However, I would like to use Time Tracker Log field type instead of Duration filed type. The formula does not turn any results when the field type is Time Tracker Log unlike Duration field type. Would you be able to help me with this? Thanks in advance!
At about 11:43 you mention being able to format that number as hours and minutes. Can you elaborate on what that formula would look like? It's exactly what I need to do in order to display durations all the same, and I've been searching for a long time to figure it out. This video is so far the only thing that mentions it.
Hey @gareth! You mentioned its possible to convert hours into hours and minutes format (hh:mm). Can you please provide an example for that! I've been trying to to this for months now, with now success. I would like to rollup tasks times as you do, and than format it user friendly like ( 2:18 instead of 1.32h) thanks a lot man!!
When you analyze a duration field in a formula, you'll see a numeric output, I believe in seconds of the total duration. You can divide by 60 to get minutes, again by 60 to get hours, etc. If you need both, use the round function as well!
Cool! I was wondering if we can format our formulas. I have a formula that should display a "currency" type, but I don't want to CONCAT the Euro sign at the end, cause I'm using that same formula field elsewhere, but still I'd like to format it. Can we do that?
Formula formatting is coming, but not here yet. For now, I'd suggest making two fields, one with the formatting, and one as a pure number. Use the number field for further math applications and the formatted field for visual reporting
What would you say is the best way to learn functions. Im really not a functions guy even in excel. I have a nocode app and the data is in airtable. I want a function to Filter the database and show the highest and lowest vlaues. FilterbyFormula=((MIN), (MAX)) is that possible?
You can write a function that outputs the MIN and another function that outputs the MAX. You'd probably want this in two different fields. In regards to learning functions, Airtable has some great free resources and there are lots of content creators teaching this, too.
Get our *free automation training* 👉👉 garethpronovost.com ⚡⚡
Start a *free trial with SmartSuite* 👉👉 partners.smartsuite.com/8ust3byf6ihl 🤓🤓
Brilliant thanks Gareth - how would we show time tracking filtered by date range i.e. this week or last week for example ?
great content Gareth!
Been learning from you about airtable just due to personal curiousity. However, now that I own a small company, I follow you closer to implement solutions.
Thanks to you, I'm moving over to SmartSuite, which I believe is a better overall solution, to actually build a system.
thanks a lot sincerely for the great content
I have a use case for the content in this video as well. However, I would like to use Time Tracker Log field type instead of Duration filed type.
The formula does not turn any results when the field type is Time Tracker Log unlike Duration field type.
Would you be able to help me with this?
Thanks in advance!
Hello, Thanks Gareth How can we link Working hours and ristrict new records on Holiday which we setup at workspace level ?
At about 11:43 you mention being able to format that number as hours and minutes. Can you elaborate on what that formula would look like? It's exactly what I need to do in order to display durations all the same, and I've been searching for a long time to figure it out. This video is so far the only thing that mentions it.
Hey @gareth! You mentioned its possible to convert hours into hours and minutes format (hh:mm). Can you please provide an example for that! I've been trying to to this for months now, with now success. I would like to rollup tasks times as you do, and than format it user friendly like ( 2:18 instead of 1.32h) thanks a lot man!!
When you analyze a duration field in a formula, you'll see a numeric output, I believe in seconds of the total duration. You can divide by 60 to get minutes, again by 60 to get hours, etc. If you need both, use the round function as well!
Cool! I was wondering if we can format our formulas. I have a formula that should display a "currency" type, but I don't want to CONCAT the Euro sign at the end, cause I'm using that same formula field elsewhere, but still I'd like to format it. Can we do that?
Formula formatting is coming, but not here yet. For now, I'd suggest making two fields, one with the formatting, and one as a pure number. Use the number field for further math applications and the formatted field for visual reporting
What would you say is the best way to learn functions. Im really not a functions guy even in excel.
I have a nocode app and the data is in airtable.
I want a function to Filter the database and show the highest and lowest vlaues. FilterbyFormula=((MIN), (MAX))
is that possible?
You can write a function that outputs the MIN and another function that outputs the MAX. You'd probably want this in two different fields. In regards to learning functions, Airtable has some great free resources and there are lots of content creators teaching this, too.