Sign in to join the conversation:
Based on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be greatly appreciated.
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!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
How can I change the value in one row based off of information in that row and information in a predicessor row
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
