- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 06:28 AM
Hi there,
I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this is?
Many thanks,
Tom
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 06:44 AM - edited ‎Feb 25, 2025 07:11 AM
Hi @hsat ,
I'll use a simplified example, with "Deal" string, and budget. I'll use the first part of the Deal as a percent, to compute the Producer Share.
The formula I used here:
(VALUE(LEFT(Deal, FIND("/", Deal) - 1)) / 100) * Budget
If you use RIGHT instead of LEFT, you can use the second part.
This assumes that this string is always in the same format ({Number}/{Number}). It might also make sense to specify the "Producer Percent" as a number field, and then you can use a formula to compute the Deai to display.
If you can adapt your data structure, this version would be less prone to errors.
I'd love to explore more use-cases of Airtable and automation specific to your business, if you're interested feel free to book a free call at any time that works for you 🙂
-- Best, Milan - Automable.AI
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 06:44 AM - edited ‎Feb 25, 2025 07:11 AM
Hi @hsat ,
I'll use a simplified example, with "Deal" string, and budget. I'll use the first part of the Deal as a percent, to compute the Producer Share.
The formula I used here:
(VALUE(LEFT(Deal, FIND("/", Deal) - 1)) / 100) * Budget
If you use RIGHT instead of LEFT, you can use the second part.
This assumes that this string is always in the same format ({Number}/{Number}). It might also make sense to specify the "Producer Percent" as a number field, and then you can use a formula to compute the Deai to display.
If you can adapt your data structure, this version would be less prone to errors.
I'd love to explore more use-cases of Airtable and automation specific to your business, if you're interested feel free to book a free call at any time that works for you 🙂
-- Best, Milan - Automable.AI
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 07:01 AM
Hi Milan, this was so clear and helpful, and immediately resolved my issue - thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 07:10 AM
Happy to help 🙂
— Best, Milan - Automable.AI Free Airtable consultation
