Help

Multiselect Calculation

Solved
Jump to Solution
922 3
cancel
Showing results for 
Search instead for 
Did you mean: 
shalablake
5 - Automation Enthusiast
5 - Automation Enthusiast

Im not sure how to ask this in order to look up suggestions. 

I have an order form that I created on a workstation. Based on the photographer, the client is given the options offered by that photographer. Once they select the options/services they would like I am hoping to have a field that auto adds the selections they made. 

Is there a formula or script I can create where each selection they choose can be given a designated price that can be added up for a grand total much like an invoice?

I am attaching an example of one of the photography options 

2 Solutions

Accepted Solutions
shalablake
5 - Automation Enthusiast
5 - Automation Enthusiast

I think I figured this out! with 

IF(FIND("25 HDR Photos $105 (Recommended only for homes under 2000 sq ft)", {Amoura Services}), 105) +
IF(FIND("35 HDR Photos $130", {Amoura Services}), 130) +
IF(FIND("50 HDR Photos $160 (minimum package for Airbnb/VRBO listing)", {Amoura Services}), 160) +
IF(FIND("75 HDR Photos $185", {Amoura Services}), 185)
 
 

See Solution in Thread

shubhams021
5 - Automation Enthusiast
5 - Automation Enthusiast
3 Replies 3
shalablake
5 - Automation Enthusiast
5 - Automation Enthusiast

I think I figured this out! with 

IF(FIND("25 HDR Photos $105 (Recommended only for homes under 2000 sq ft)", {Amoura Services}), 105) +
IF(FIND("35 HDR Photos $130", {Amoura Services}), 130) +
IF(FIND("50 HDR Photos $160 (minimum package for Airbnb/VRBO listing)", {Amoura Services}), 160) +
IF(FIND("75 HDR Photos $185", {Amoura Services}), 185)
 
 
shubhams021
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you, I saw this thread and was able to make it work 🙂