Calculate a Total From Checked Rows in Google Sheets
To add amounts only from checked rows, use SUMIF. The formula checks the checkbox column and adds the matching amounts from another column. The total changes when you check or …
Uncategorized
Count Checked Checkboxes in Google Sheets
Use COUNTIF to count checked boxes. For default checkboxes, count the cells that hold TRUE. The count updates as you check or uncheck the boxes. If the boxes use custom …
Populate a dropdown from another sheet in Google Sheets
If several people assign support requests, keeping the team names on a separate tab makes the choices easier to maintain. Your working tab can use those cells as a dropdown …
How to Allow Multiple Selections in a Google Sheets Dropdown
Sometimes one task needs several labels. You might mark an onboarding task for both Design and Review, but an ordinary dropdown lets you choose only one. Google Sheets has a …
Create a dependent dropdown list in Google Sheets
When one choice determines the next, a regular dropdown isn’t enough. You might want an Item menu that shows fruit only when the Category cell says Fruit. I’ll show you …