Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
