Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Breaking down a row value into weeks

Topic Labels: Formulas
420 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