Trying to Selection Multiple values from one column
Need to select multiple values from a column to sum a different column.
Where is this wrong please help
=SUMIFS({Fastrack Total Cost}, {Fastrack Build Location},ME,{Fastrack Build Location},AK,{Fastrack Build Location},OP-UNIT3,{Fastrack Build Location},Unit 1)
Answers
-
Try adding quotes around each of the "specific text" bits you have in your formula.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!