-
need to find values
here i have the data with few country names with status as pass , fail and on hold. attaching screenshots below. i need to figure out the values with the help of country names EX; AMERICAS = Pass (no of counts), Failed (no of counts) India = Pass (no of counts),Failed (no of counts) plz suggest me how to achieve this.
-
Index Formula help
Hi All, I was hoping for some feedback on this index formula I am working on. I have mapped other sheets before but this time I am getting some push back. So I took a screenshot of the sheet. The first issue I notice is that when I try to use [Account Number]2 it errors out. This same formula works using [Account…
-
Conditional Formating based on Time of the day
@Paul Newcome Hey Paul, I was following some of your threads for Formulas with time, and I found one that has been really helpful. But there it seems to be something off. I found your answer under the question "Calculating time worked for Employees". But the formula doesn't work well when you are adding minutes to a late…
-
Populating a column based on checkbox combinations
Hello! I am interested in populating a column based checkboxes in other columns. This is the layout below. The column that would be populated is Extraction Method. The Extraction Method column is a dropdown with four choices: Standard, Ampseq, Custom and Other. I would like certain combinations of the checkboxes to trigger…
-
Count String Occurrence in a Cell
Hi There, I have below two columns in my sheet. Column [Status (Delivered)] has concatenated values (WIP and Delivered). In [Delivered Count] column, I need to show how many times 'Delivered' string occurred. Please see below example.
-
Metric Sheet - Data entered during previous month
Hello! We have a project where data is entered for an individual client on a monthly basis. We have created a metric sheet so we can share aggregate data in charts on a dashboard, and have set it up for the two enrollment statuses that only occur once ("referral" and "discharge"); however, we are struggling with how to…
-
Use of countifs when multiple dropdown values are in cells
I'm attempting to count a range of cells (columns) where the value may have one or more values included in the cell from a dropdown value. Example: Workstream may have "Architecture" "testing" "UAT" included in the cell in one instance and in others only "Architecture". My formula seems to be counting only if…
-
Convert to Column Formula option is missing from my menu
Hi, I'm the Admin of this sheet, but when I right click on the Formula column, I don't see the option to 'Convert to Column Formula' in the menu. Am I missing something?
-
Report based on multi select dropdown
Hello, I want to tie in an employee name with their development interests (Multi drop down) to the actual projects they have been assigned to and the business area that coincides (another multi drop down) End result would look like this and I would want to include in a dashboard. Name - interest- Task - business area John…
-
If Function
I'm trying to do an IF function per below but doesn't seem to work. Basically, if it's Amazon or iTunes, it should be "Ordered_Output Platform" and any other category should be "Need to Avail" =IF(OR(Platform@row = "Amazon PVD Prime Video Direct", Platform@row = "iTunes (Apple TV)", "Ordered_Output Platform", "Need to…