Add Numeric Fields together if a checkbox is checked
Hi, I'm building an app where the project is projecting out 5 years, but the project owner might only ask for funding for 1 or 2 years (to keep costs manageable, but they need to project to 5 years)....
Try this
IF([Year 1 Ask], [YEAR 1],0)
+
IF([Year 2 Ask], [YEAR 2],0)
+
IF([Year 3 Ask], [YEAR 3],0)
+
IF([Year 4 Ask], [YEAR 4],0)
+
IF([Year 5 Ask], [YEAR 5],0)
