-
Cross Sheet Reference/ sum values
Looking to VLOOKUP into one data sheet to find - a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount. My formula example:…
-
Countif on Checkbox column type
Hi, I am trying to get the % of tasks complete. The column is a checkbox type. This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked) =ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%" I need to add a Count if ES2:ES36 contains only 1 or 0, so if the column is set to N/A then…
-
Where is referenced field
Ok, first, I took over this sheet, report, dashboard from a former employee and out of nowhere a sheet stopped working. I know the problem, just trying to determine how this happened and how I can fix it. There is a cell with a formula. The formula references a field in some other sheet. How can I determine where it is? If…
-
Add two values in the one colum
Hi, I am trying to add two different values from the one column in the sheet summary and keep coming up with an error =SUM(COUNTIFS([Lease Due In]1:[Lease Due In]130, "Due in Next Month", COUNTIFS([Lease Due In]1:[Lease Due In]130, "Due in Next 3 Months"))) The error is #INCORRECT ARGUMENT SET I have tried a few different…
-
Formula to add multiple dropdown with a criteria
Example Column 1 banana orange watermelon Column 2 kid 1 kid 2 kid 3 I want to create an equation that counts, how many times kid 1 has chosen banana and orange???
-
Due date formula based off priority
I'm trying to have calculate a due date based off the priority (high , medium, or low), add 1,2, or 4 days to the date submitted. I'm using something like the below, but getting an error. Any help? =IF([Business Priority]@row = "High"), [Date Submitted]@row + 1, IF([Business Priority]@row = "Medium"), [Date Submitted]@row…
-
if text in column a is "X" then apply numeric value to column b..help?
Hello! I apologize in advance as I'm sure this is super simple, but for some reason I'm having a hard time and frankly have spent too much time (staring at it, searching formulas, trying+ failing etc ;) ) when I'm sure you smarties can help! What I'm trying to do: if text (a specific text/phrase from a dropdown option) in…
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
At Risk Flag Formula Help
Hello, I currently am using the below formula in the At Risk column which works just fine. If baseline due date is 3 days out and status is not checked off as complete as well as % complete is not 100%, flag as at risk. =IF(AND([Baseline Due Date]@row <= TODAY(3), [Baseline Due Date]@row >= TODAY(), Status@row <> "Yes", [%…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…