-
Sheet with Mapped Column No Longer Working
I'm having issues with a sheet that has a column mapping users for a filtered report. The sheet has two columns - PDS Selected that captures sign-ins where session hosts are selected, and PDS for View, a column that maps to PDS Selected and is formatted as a Contact List. This then filters to a report set to Current User.…
-
Expand Count formula (To provide a list of names from another column)
Hi All, This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help. I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column. In a corresponding column I have a reference to a company name which I would really like to display on a…
-
Is there a formula to return a value if all of the cells in a column contain a specific string?
Hi, This may be a naive question, but is there a formula to return a value if all of the cells in a column contain a specific string? This will be part of a nested IF statement that returns different project statuses. For example: if any cells in Column 1 contain “in-progress”, then return “In-progress”, but if all cells…
-
Newbie help :) If a cell is blank, display content from another cell
Hello! This is probably so simple but I can't seem to get it right. Cells: Name, Draft Name This is what I'm trying to do: If Name is blank, show draft name, else do nothing. =IF(ISBLANK([Name]@row), [Draft Name]@row,” “) Appreciate any help I can get. Thank you!
-
Change date format
Hello! How do I change the way a date is displayed? I need to change dates displayed as ""yyyy-mm-dd" to "yyyymmdd" for a report. Thank you!
-
Change Date based on Symbol
Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I need to create a due date based on the Priority chosen and the date the form was entered. I was able to build that initial…
-
Combine 2 IF CONTAINS formulas searching 2 ranges
Needing some help. I am running 2 sheets a master project sheet and an audit sheet populated off a form. I have an IF CONTAINS formula that works to check a checkbox on the master project sheet when an audit is populated in the audit sheet with a unique number. =IF(CONTAINS(UN@row, {Audit Template Range 1}), 1, 0) I want…
-
Help with translating text values into numeric values for graphs
Hello! I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown column and each option will be a bar on the graph. I'm having a hard time separating the data first by team and then second…
-
Dashboard Chart to Show Rolling 12 Months
I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which those products will be implemented. I then have 3 rows for 3 different product types. This data is pulled from a Summary Sheet.…
-
How to input data into target sheet from a source without a unique ID
For context, I am mining public clinicaltrials.gov records to associate unique trial records with results publications. There are often multiple results publications linked to an individual trial record. I have a sheet of my institutional records, each record has its own row and is uniquely identified by a national…