-
Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell?
Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell? In my template is used for testing. It contains a contact column and a column where a person should advise if something passes or fails. The pass fail cell contains a default value e.g.: Select Pass/Fail from the dropdown. When…
-
Asset Availability Formula
I am trying to create a formula which allows me to input 2 sets of dates (a check-out date and a due date) which will then present me with the availability of the total assets between those dates. Does anyone have a formula that calculates availability based of existing availability/unavailability? I hope this makes sense.…
-
Count Repeated Values
Hey Team, Please, how could I count repeated values in a column? I have a grid with a column called a quarter, and I would like to count how many times Q1, Q2, Q3, and Q4 appear. Thanks in advance, Andre Menezes
-
Issue with allocating data in Chart Widget
I created a chart using the chart widget on our team dashboard and finding it difficult to have the data displayed correctly. I created a sheet and added the following columns "Office" and "Status". The permissions for the "status" option includes a dropdown with the options "In progress" and "Completed". The chart…
-
Budget calculation by specific association
This is probably very simple to most. :) I'm building a dashboard, and want to track expenses by individual association. I've taken the online tutorial, but just can't make it work. Any support is appreciated.
-
Return MIN date from another sheet if criteria are met
Hello community! I am trying to return a date value from another sheet if criteria are met. TIME SHEET The date on the first row uses this formula: =DATEONLY(MIN({StartDate})) + "" It is pulling this information from the PROJECT PLAN SHEET start date column: I need the formula in the highlighted cell of the TIME SHEET to…
-
Formula: calculate percentage based on certain criteria
Hi, please can you assist? I have 2 worksheets, called "Position Requisition" and "Dashboard Data". In the "Position Requisition" I have two columns, called "Total Train ATTR" and "Location" In the "Dashboard Data" I have two columns, called "Primary Column" and "Totals" I want to add up all the totals in the "Total Train…
-
Formula to avoid the count of duplicate text entries
Hello, In one of my sheets, I have the formula to count the number of partners (existing and new). But I need to avoid the count of multiple entries for the partner names. See the image below: As you may notice the Partner - "GTA" was selected in two different rows and therefore it is counted twice in the # Partners…
-
How can I write a COUNTIFs using a dropdown in one argument and not another?
I have 2 columns that I am trying to do a sheet summary on and can't figure best way to write. one column is a free text and the other column is a drop down list with several months. I need to get the counts of "Leaders" who select certain months (Oct, Nov, Dec, etc). Can this be done using CONTAINS ? =COUNTIFS($[Leader or…
-
Extract text from Cell String using delimiters “|” into separated columns
Hello wonderful community, I need your help on this. I have cells that I need their text extracted into columns. Text in cells is not always the same length, so I cannot just count the characters. Example of cells look like CANADA | ID NO. 78989 | “JUAN” | IN COHORT(S) 1, 5 | SPONSORED WITH LEGACY USA | ID NO. 19667888 |…
