-
Formula error - Incorrect argument set
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
-
Viewing Data After Automation
I have a form attached to an "intake" sheet. That sheet receives the data, then pushes it to one of two other sheets depending on the response in certain fields. The intake sheet, according to this workflow, should always be empty. We had a row push to the appropriate sheet but some fields were missing. I'm trying to see…
-
Formula to count # of tasks overdue based on date
What is a formula to count the # of tasks that are overdue, based on a date?
-
Updating Health Formula to Include Blue Status for Completed Tasks
This discussion was created from comments split from: Multiple IF/AND Formulas - Need Nesting Help.
-
Cross Sheet Countifs w/ Checkbox
I am trying to write a cross sheet countifs formula. (COUNTIFS({Ref. Sheet Column}, [Requirement Name]@row , {Ref Sheet Checkbox Column}, 1 > 0) Something isn't right as I am expecting to return a checkbox on the target sheet where the formula is being written based on the conditions of the source sheet. Thank you
-
Drop Down List
I would like to have a dropdown list based on a dropdown list from another column. EXAMPLE: Column A = Main Category (Accounting, Collections, Payables) Column B=Sub Category (If Column A is Accounting I would like Column B to only show drop down options (GL, Transfer, Set up, Close) associated with Accounting. If Column A…
-
Replace column of data from Excel snapshot
I had data deleted from a column in a tracking sheet. (2K+ rows) I pulled a snapshot from the activity log and I want to pull back the data from just the one column. I was told the right process was under File>Import>Update Rows, but I don't have that option under import. Is there another way to do this?
-
COUNTIF a cell is NOTBLANK
I need help counting the data in a column if a cell on that row is not blank. I want the count of Serial numbers from the "Serial" column if the actual completion date field is blank. This is the current formula I am trying to use that is not working: =COUNTIFS([Actual Completion Date]:[Actual Completion Date], "",…
-
Chart generated using AI "Analyze data" function won't display on dashboard - how to fix?
I have an sheet that lists all of the projects for our department and one of the fields is called "Roles Involved" - it is a Dropdown list where users can select multiple values but entry is restricted to the list values. Using the AI "Analyze data" function I created a bar chart that counts the number of projects for each…
-
Game badges
I played all the games and requested the badges but I do not see them on my profile?