Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
We currently have a SUMIF formula that sums up a Annualized Estimate for a specific Ministry. The Sheet with this data uses a form to populate additional rows. The currently working formula is =SUMIF(Ministry:Ministry, [Ministry Name - Annualized Estimate], [Annualized Estimate]:[Annualized Estimate]) We wanted to break this down further and add our year column to the formula to show the Annualized Estimate for a specific year rather than summing all of the Annualized Estimate for a specific Ministry. Our year column is named GAP Year and it is currently a drop down menu of 2017 and 2018. This drop down is restricted to 2017 and 2018 but we may want to make a check box that will allow us to select both 2017 and 2018.
I believe I need to change the formula to =SUMIFS but from there I cannot seem to find the correct format to include the year criterion.
Basic thought would be: Take the Annualized Estimate ($) for a specific Ministry and a specific year(s) and add them together.
I appreciate the help.