Community

I'd like to add some conditional formatting to the answer calculations on Drayage Total Amount Estimate. Previously i'd use the IFS statement and separate the answers out to not overlap but im running into an issue with out updated logic. When the question Delivery Type is Drop And Pick, then there isn't an impact for appointment required. If the job type is live unload than the appointment answer will impact the total costs. What are some formulas and functions I could use for conditional logic?

Andy Dean

Mar 27, 2024

Comments (1)

Vipin

Mar 28, 2024

Hi Andy, you can use the IFS function to add conditional logic to the calculations. Please note that we do not have the option for conditional formatting. IFS function: Evaluates multiple conditions and returns a value that corresponds to the first true condition. Syntax: IFS(condition1, value1, condition2, value2, condition3, value3, … ) where condition1 - The first condition to be evaluated value1 - The returned value if condition1 is TRUE condition2, value2, condition3, value3, … - Additional conditions and values if the first one is evaluated to be false. Example: You have added a multiple choice question "Type of Job" with "Live Unload" and "Drop And Pick" as answer choices. Similarly, you have a multiple choice question "Appointment Required?" with "Yes" and "No" as answer choices. If you would like to calculate an answer or set a value based on the answer selected for "Type of Job" question, then you can use the below formula. IFS(Type of Job == "Live Unload", 250, Type of Job == "Drop and Pick", 500) If you would like to calculate an answer or set a value based on the answer selected for "Type of Job" question and the "Appointment Required?" question, then you can use the below formula. IFS(Type of Job == "Live Unload" && Appointment Required == "Yes", 250, Type of Job == "Live Unload" && Appointment Required == "No", 0, Type of Job == "Drop and Pick", 500) Note: 1. You must type @ and select the field from the list when adding the formula in the calculate option 2. Instead of assigning a value such as 250, 500, you can also add formula to calculate an answer. 3. You can use the && operator to check for the AND condition, || operator for the OR condition.

Add your comment