If column A status is X then tally column B

Options

Tammmitha

Tammmitha ✭

06/21/19 edited 12/09/19 in Smartsheet Basics

How do I do this?

If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status.

Thanks

Tags:

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

06/21/19
Options
Try something like this...

=IF([Column A]@row = "Pay Supplier", SUMIFS([Column B]:[Column B], [Column A]:[Column A], "Pay Supplier"))

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!
Alert Triggered by sum threshold on a specific cell
Hello all, I have a need to alert the person in charge of the spending when the total spending reaches a certain threshold. Actually, multiple levels would be ideal. The source sheet pulls invoice totals from several other sheets and adds them up on a monthly basis. After the calendar month is over, this sheet will…

Help shape the future of Smartsheet.
Share your ideas and feature requests.