Cross Sheet Formula - SUMIFS

Brian R.
Brian R.
edited 05/29/24 in Formulas and Functions

Hi there! I have built a summary sheet summing revenue that is captured from another large sheet of data, including criterion such as Product Type between 2023 year date range, however, it's unparseable and I believe it's due to a paranthesis or something tiny I'm overlooking as the reason why it's not working. I. hope so anyway. Here is the formula. Can anyone see anything that could be tripping this function up?

=COUNTIFS [DMS - Material Request Sheet (Shows) Product],[Show Spotlight],{DMS - Material Request Sheet (Shows) Range 2},{040123-123123})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!