If column A status is X then tally column B

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 Community Champion

06/21/19

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

Can't create an X-axis on a scatter plot
Hi there. I want to make a scatter plot that graphs points based on the following two pieces of data: impact score and design hours. My issue is that I can't get the X-axis to display the content in my design hours column. Here is a picture of my scatter plot. The dark blue points at the bottom of the Y-axis shouldn't be…
Automation Copy Rows - Select a Destination Sheet
Hello, I'm running into an issue I've found through past forums. I'm attempting to copy rows from one sheet to another. I am the owner on both sheets. What could be the cause of this? Both sheets are in the same folder… Thank you
Filling a Contact List from another sheet
Hello everyone, I have a sheet that has a list of all of the managers and supervisors in my organization and I keep it updated monthly. I have another sheet that has a Contact List field and I am trying to see if there is a way to connect the Contact List field to the Sup/Mgr sheet, so that it automatically updates when I…

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