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, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
