Calculations from inspection questions

Hello,

Yes this can be done, please see image attached.

Q1 air in

Q2 air out

Q3 delta t

have all of the answers set to numbers, on the detla t question click format (number) select calculation and put $air in minus sign - $air out that will automaticall populate the answer

Hi @RV P. I. thank you for your enquiry and @Ady thanks so much for jumping in and sharing your use case! 

For more info on how to use this feature check out the below link to the help centre article: https://help.safetyculture.com/en-US/002991/

Is it possible to evolve this feature even further??? 

It would be advantageous to include the slider function within the Calculations function, either by allowing you to set the minimum/maximum fields with numbers set in previous questions (by using the same, current format, $’name of questions’, and the same inverted function, by allowing the values declared when using the slider function to be made available to use in calculations. 

Furthermore, can the formula functions be expanded to include greater than >, less than <, equal to =, with a warning notice being issued of the calculations results in a false result? 

thanks, 

Thomas

Hey @TMcG ! You raise a great idea! I want to make sure our Community has the best visibility of it so I encourage you to submit a new idea so there’s no confusion associated with this one and the idea it’s been merged into. Let me know if you have any concerns 😊

I would like to see more advanced formulas, involving IF statements with <, >, =.  I would also like to be able to calculate the difference between date and date/time questions.  

For example, I have “Production Date/Time of First Unit” and “Production Date/Time of Last Unit.”  I want to calculate the days between them including the time as a decimal for partial days.

Another example - I have a calibration standard value and a question for the actual measured value.  You may have 3 sets of these for 3 calibration standards to measure.  I need to say “SUM(IF(value1-standard1 > xyz, 0, 1), IF(value2-standard2 > xyz, 0, 1), IF(value3-standard3 > xyz, 0, 1))”.  That would result in a total sum of 0 to 3.  I can then use logic on that result to say if >= 2 you pass.