-
How to fix this issue i am getting with Sum and trying to add a qty based on a budget number
I want to sum a number of quantities based on a criteria that checks the budget number to the row in the purchase request sheet that has the same budget number to then add all those quantities up in a cell in the budget so this way Each budget line that is used in a purchase request the qty of how many items purchased isโฆ
-
Collecting Dollar amount with two reference columns
Hello everyone, I'm in need of some help with collecting a dollar amount from one sheet to the next. My issues are the following; I have to collect the amount after meeting specific criteria. Of those being the "name" or "ID" in one column and then within a specific "date range" in a different column. For example: on sheetโฆ
-
Help with a COUNTIFS Formula by Month and by Year
Hi everyone! I am hoping you can assist me. I need to count the number of times a specific action is completed by month and year. The column with the actions is titled "FFP Line-Item Number", which appears as Range 1 in the formula. The one thing I see as a possible problem is the person who designed the tracker hasโฆ
-
Dynamic View not showing the values of a formula column that is a Read-only in the data options.
When trying to add a new item on dynamic view after i have picked my question category it should return a specific question on the next line (with no changing option, read-only). It does not show my specific question, after i hit save for the new entry it does show. But the problem is that i need the submitter to see theโฆ
-
Can you create an IF Statement using the following?
If Actual Build Date is Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Not Started" If Actual Build Date is Not Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Factory" If Actual Build Date is Not Blank, Clear to Ship is Not Blank, and Actual Ship is Blank, then put "Clear To Ship" Ifโฆ
-
SUMIFS & CONTAINS formula
Hi, I'm trying to identify the # of request types by a specific job title. The source of the data is on another sheet. The formulas I have tried so far have been producing zero as a result (which I know is incorrect based on the source data). =SUMIFS({Request Type}, {Request Type}, ="Initiative / Project", {BranchJF},โฆ
-
IF Statement with ??? to move cell data
I have the below as my main sheet (plus additional columns that aren't relevant). Then I have a separate sheet for each Name. On the separate sheet I want to record the "Unique Identifier" if "Approval" = Approved. Originally I thought of combining an If statement with index match but don't have anything on the "Name"โฆ
-
COUNTIF, one cell is text, and one cell is 'check box'
@Kelly Moore I have a summary formula that works to count a cell if there is text in it, works good, can weed out the Data that I don't want to count with other summary formulas. However there is often preplanning or left over data. My solution is to show the [route] completed [done]. =countif([done]:[done],1) worksโฆ
-
Workflow Questions
Hello: I have two questions that I hope someone can help me with. 1) If I have a bunch of workflow items (calls, emails, texts) laid out on a daily cadence until the person responds. Is there a way to automatically mark them as 100% as soon as they respond, and I enter a Start Date in the next section? 2) Is there a way toโฆ
-
Help with setting a symbol color based off calculation
Hello, So I have two columns. Actual and Budget I want to calculate the difference between the two, and then if the difference is lower than the budget number, the indicator symbol would be green, else if it is higher, the indicator symbol would be red. Thoughts on how that would look in a formula. TY