Looking for Formula
Comments
-
Try
SUMIF([Project Stage}:[Project Stage},"Paid", FEE:FEE)
-
You could try something like this. Not very elegant though. I may look at this a bit more after work
.
=SUMIF([Project Stage]2:[Project Stage]19, "PAID", FEE2:FEE19)
-
Ah, sorry... Looks like rjudenberg has the answer.
-
With one minor adjustment rjudenberg had the right answer:
SUMIF([Project Stage]:[Project Stage],"Paid", FEE:FEE)
His close brackets on the Projects Stage range were curly brackets which could cause some confusion for Smartsheets and curly brackets tend to point to a range in another sheet.
-
This worked perfect, because I am linking to another page the formula came to be this:
=SUMIF({Mimi's Project Management 2018 Range 7}, "Paid", {Mimi's Project Management 2018 Range 3})
and
=SUMIF({Mimi's Project Management 2018 Range 7}, "Invoiced", {Mimi's Project Management 2018 Range 3})
Thank you rjudenberg!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!