Help

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

Forumla Help on Multiselect field

Topic Labels: Formulas
561 1
cancel
Showing results for 
Search instead for 
Did you mean: 
VentureOff
4 - Data Explorer
4 - Data Explorer

I am struggling to find the formula that I need.

I am trying to calculate the total guide cost for a trip.  I have a multiselect field for the guides that will be on the trip, then in the guide table, I have their rate per hour of guiding.  So on the main table, I have a lookup field that displays the rates for each guide.  I need to now multiply each rate by the 8 hours and then by the total number of days they are out,  and add them together.  

VentureOff_0-1689676281383.png

https://airtable.com/shrDEDCYEnQAlksAF

 

 

 

1 Reply 1

Hi,
Change lookup field to rollup, SUM(values). Multiply it by 8 and total number of days.