ContributionsMost RecentMost LikesSolutionsTotal of a Multiple Choice Column across Multiple Fields Hello, I have a report where each record is a building. The information is broken down to show where region the building is in (there are four regions) and then show the risk of four different areas within a building and assigning a risk level.Users can rate those areas as high, medium, low or complete. I need to show within a summary report for each region how many of these are high, medium, low or completed. I have tried stacking an If() formula but it currently will override later statements and not produce the correctly totals. I have a formula that looks and summarizes for each record how many have matching values: Sum( If([Area1 Risk]="High",1,0), If([Area 2 Risk]="High",1,0), If([Area 3 Risk]="High",1,0), If([Area 4 Risk]="High",1,0)) Is there a way to use this information to help summarize and show the correct totals? Here is what each value should be totaling: Completed: 94 Low: 66 Medium: 75 High: 49 Total: 284 ------------------------------ Sarah Driscoll ------------------------------ Re: Button to Redirect to an Editable Form in Another App Wow...way easier of a formula than I was trying! Thank you so much! It is working perfectly :) ------------------------------ Sarah Driscoll ------------------------------ Re: Button to Redirect to an Editable Form in Another App When I use that last formula, I get an error that the record can't be found but I know it is there. The records id #'s are different from table to table but the Project ID #'s are the same and are the key's in both apps. is there anything additional that would need to be written into it? ------------------------------ Sarah Driscoll ------------------------------ Button to Redirect to an Editable Form in Another App Hello, I am trying to create a button that will redirect users to users to the same record in another app where they can edit information. I've used several different formulas with partial success. Below is all relevant information: Table ID I am trying to redirect to: btan5p92a?a?a Matching Field ID in other app: 261 Examples formulas I have written utilizing the Formula-URL field type: 1) URLRoot() & "/db/btan5p92a?a?a" & "?act=API_EditRecordForm&_fid_261=" & [Project ID] & "&z=" & Rurl() 2)URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=API_EditRecord&rid=" & [Project ID] & "&rdr="&URLEncode(URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=doredirect&z=" & Rurl()) Both formulas redirect to the apps homepage, but not to the specific table or form. Is this possible to create? ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form That did the trick!! Thank you! ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form Here is my current formula. ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form So the error is no occurring around the re-direct part of the formula and is showing the same error as before ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form I'm getting an error at the second ampersand. It says that it is sepxceting text. I tried changing the field type to rich text and URL with no luck. ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form It does look like I can add that to the form rules. ------------------------------ Sarah Driscoll ------------------------------ Re: Button to only show specific part of form Hi Mark! It would be with the new forms. I currently have a button on a report that ideally, when clicked, it would only show that specific section of the form. I was thinking if I altered the formula of the button to essentially say when clicked, go check this box. Then in the form rules I could say what you mentioned above. I didn't even think that I could put into the form rules to uncheck from there. Not sure if that logic is sound and would work or if this isn't possible. ------------------------------ Sarah Driscoll ------------------------------