Relative Content

Tag Archive for google-sheets

How to find percent from drop down options in google sheets?

I use a rubric for data collection. I am trying to compile it onto an excel sheet for user-friendly accessibility. I have put the content criteria in separate column drop down menus. I need to calculate the percent for each column, and each drop down item individually. enter image description here

Repeating the same formula across rows and create a sum total

I would like to repeat the same formula across multiple rows and then calculate a total sum. Eg. for each row I would like to sum the number of days and multiply that with a day rate and then calculate the total sum for all rows. Currently, I am manually changing the references for each row, but I was hoping I could create the formula once and then pass an array of the rows instead

Adding row splits data validation Google sheets

In the Test spreadsheet here I created a budget table that has dependent dropdown lists. When you select a category in the Main table, column F, in the Subcategory column (G) another dropdown list appears, based on the Category selection. It works fine and I am happy with it except for when I add a row in the main table, data validation in column G (Subcategory) splits and range reference is not good anymore.