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.

Forumla Help on Multiselect field

Topic Labels: Formulas
711 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
Alexey_Gusev
13 - Mars
13 - Mars

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