Community
        
        
            
                
                    In this form I have 6 Categories (Certainty, Uncertainty, Significance, Love/Connection, Growth, and Contribution). Each category has its own point system, and the totals are added at the bottom. I want to create a conditional statement that outputs which category scored the highest. Is there a way to create a conditional statement that says, for example, If Certainty Score> Uncertainty Score/Significance/Love/Connection/Growth./Contribution The output Certainty score?
                    
                 
                
             
         
     
    
        
        
     
Comments (3)
Jun 24, 2024
MAX function You can use the MAX function to find the highest value in a set of give data. If you have added 6 fields -- Certainty, Uncertainty, Significance, Love/Connection, Growth, and Contribution -- in the form to calculate the category scores, then you can use the MAX(Certainty, Uncertainty, Significance, Love/Connection, Growth, and Contribution) to find the highest score of the 6 category scores. TITLE function If you would like to find the field with the highest score, then you can use the TITLE and MAX function. TITLE(MAX(Certainty, Uncertainty, Significance, Love/Connection, Growth, and Contribution) The above formula will return the name of the field with the highest score. For example, if the Significance category has the highest score, then this formula will the return the name of the field for Significance. Note: You must type @ and select the fields from the list when adding the formula in the Calculate option.
Apr 8, 2025
Thank you very much; it worked like magic. Now, if you don't mind, I have another question. Since it's not possible to display graphs, I want to present the numbers using the REPT function. However, the software is giving me an error. I tried even something simple, and still, it shows me an error. Do you know the reason? Attached is a screenshot. -
Apr 19, 2025
Hi Anat, Formfacade does not support REPT function. If you would like to display graphs, you should subscribe to the Formfacade Enhance paid plans. Formfacade Enhance pricing https://formfacade.com/enhance/pricing.html
Add your comment
Add photo