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

Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…