Not sure why this isnt working

stephanie trowbridge

stephanie trowbridge ✭

07/27/20 in Formulas and Functions

=SUMIFS({Sheet - Grant Management Range 1}{Sheet - Grant Management Range 2}, "Approved"{Sheet - Grant Management Range}, "2020"

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

07/27/20

You are missing commas.
=SUMIFS({Sheet - Grant Management Range 1}, {Sheet - Grant Management Range 2}, "Approved", {Sheet - Grant Management Range}, "2020")

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box. So all…
Formula to populate field from another sheet using multiple criteria
Hi there, In one sheet ("pay scale") I have our employee pay scale and in another ("Employee Salary") I have our employees listed with their experience and education levels. Is there a Smartsheet formula that I can use to pull in their salary based on their experience and education levels? For example, if they have a BA +…
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…