Welcome!

If column A status is X then tally column B

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

Finance

Try something like this...

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

Unlicensed Users cannot enter data in the sheet, when they could before the changes
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
2 of 5 automation workflows in a SMartSheet randomly stopped performing?
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.