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!
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
I have a holiday sheet for Team Members to log their holidays: Assigned To, Start and Finish Date. A formula has been created to flag the status of when they are ‘On Holiday?’: eg, ‘Holiday Complete, ‘On Holiday’ and ‘Holiday Booked’. Based on this status, an ‘Availability’ symbol also appears Id like to use this…
