-
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…
-
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…
-
SUMIFS with Multiple Criteria
Hi, I am trying to create a summary formula for Work-in-Progress (WIP) value on a KPI summary sheet, using data on a secondary sheet. I need the formula to do the following: * Only look up values that have a WIP% figure greater than 0 * If a WIP% figure is available, divide the total value by the WIP% * Add all of these…
-
Formula value
Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information. I currently use the Paste special but…
-
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…
-
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…
-
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???
-
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…
-
What is wrong with my nested IIF THEN ELSE statement?!
I typically do not have issues with calculations - I am sure that this is a really stupid mistake I am making - but what I am doing wrong with this nested IIF THEN statement?! iif ([Data Type] = "Income Statement" THEN iif([Data Type]="Net Sales" THEN [Value] else "" END))
-
Month/Year Row Count Function
Hello All, Can someone help me figure out why this formula is not working anymore? =COUNTIFS({OSPO Engagements Archive complete date}, IFERROR(MONTH(@cell), 0) = 1, {OSPO Engagements Archive Hierarchy}, =0, {OSPO Engagements Archive complete date}, IFERROR(YEAR(@cell), 0) = 2019) It used to count all of the rows for a…
