Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Breaking down a row value into weeks

Topic Labels: Formulas
536 0
cancel
Showing results for 
Search instead for 
Did you mean: 
christophe_spen
4 - Data Explorer
4 - Data Explorer

I don’t know if this is possible to do - but if so would be of huge value to me.

My Challenge:

I have records in Airtable that contain ‘Media Bookings’ for advertising campaigns

As an example:

Campaign: Launch
Site: Youtube
booked Impressions: 1000000
Media Cost: $15000
Start Date: 01/10/2022
End Date: 31/12/2022

I need to easily convert this information into ‘Week commencing’ detail so that I can prorata the impressions and cost based on weeks of the campaign
e.g. W/C 03rd October, 10th October

Value of doing this:
this would help significantly with monitoring pacing of campaigns, and suporting accurate invoicing of costs to clients

Is there a way of doing this within Airtable…

thank you so much for your help!!!

0 Replies 0