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.

Multiselect Calculation

Solved
Jump to Solution
2274 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
shalablake
5 - Automation Enthusiast
5 - Automation Enthusiast

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