-
SUMIF children using a drop down column
I want to use SUMIF, to sum up, a specified amount of money based on a drop-down column. I would like this to dynamically change the total amount shown depending on the chosen drop-down option. Is this possible? This is a formula I tried but the logic of course isn't there: =SUMIF(CHILDREN([Report Row]:[Report Row]),…
-
Countif Formula in Sheet Summary not giving results
Hi, Just wanted to check with the community if there was any change to the criterion selection under the "COUNTIF" function. I have a column formula for a checkbox column in a Smatsheet that flags if I get a result and the sheet summary calculates if the box is checked using "COUNTIF". I was seeing the results in the past…
-
SUMIF Formula help
Column A has various business units and column B has the number of resources. I am trying to sum the total number of resources for each primary business unit. The challenge is some business units have subunits and i need to include these in the sumif formula to get the total number of resources for all related business…
-
Cross-Sheet Functions
I am trying to return values to a new sheet from a form sheet if the cells in a particular column of the form sheet contain any data. For instance, if FORM sheet column 4, row 1 contains data, put that data in the NEW sheet, column 1, row 1. If FORM sheet column 4, row 2 does not contain data, then no action. If FORM sheet…
-
Is there a formula or shortcut to change text to Proper case?
I have a very large sheet where some of the text was written in upper case. I know the UPPER and LOWER functions will change the entire sentence to lowercase, but is there a PROPER function (like in excel) to capitalize the first letter of the sentence with the subsequent letters in lower case?
-
Counting values in a column if different column shows certain value
Hi all, this is my first question to the community. Here's the dilemma I've been braking my brain about for a while... I have a sheet and would like to add a Sheet Summary Field that does the following: If in column "Name" the name is "John", add all values together found in column "Value" for John. Same for Chris and…
-
workflows
can a workflow be set to work like this somehow if area of business = Whittlesey and proforma raised by is any value the email email 1 if area of business = Hoveringham and proforma raised by is any value the email email 2 if area of business = London and proforma raised by is any value the email email 3 and so on as the…
-
How to Sum rows in a column based on date
I have a sheet set-up with distinct numbers project numbers in the rows with columns containing the months of the year. Each month I drop in actual activity for the current month and someone will forecast their spend for the remaining months of the year. Is there a way to have a formula that adds up the columns with actual…
-
Round date down to the nearest Monday
I have a column of dates and I need to create a column that would use that date to round down to the nearest Monday so i can count how many lines of data for a specific week with a date. I was able to get the week number but really need the date.
-
Combining If Error formula with my existing formula.
I currently have a margin formula calculating my profit margin. This formula looks like this =(Description5 - Description7) / Description5 When the sale price and landed cost are zero. I want my margin calculation to show 0% instead of #Divide By Zero. I know I need to use If Error formula but I ma not sure how this needs…
