-
Joining two columns together for rows that match criteria
Hello, I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet. So far we have =IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", ")) And get Data2, Data2,…
-
Re-occuring "Row" event reminder
Allow a row reminder to be set to repeat, I.e., every 3rd Thursday, every Sept 1st, etc.… over a more extended period vs. one at a time and having to recreate it. The current process is a more involved task of creating a workflow and setting conditions for EVERY row that needs a reoccurrence.
-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
How can I pull only certain info into a report
Hello, Is it possible to only pull information into a report? EX: If my assigned to column is blank, I don't want that row pulled into my report, I only want the rows that are actually assigned to someone. Is that possible? Thanks in advance!
-
Help to Sort by number and words
currently we have a built in prioritization score based on the data entered on the intake form This will populate either a score of 1-5 OR the word "Tech" When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first I am…
-
Alert when tasks are planned to finish after a date in another task (deadline)
Hello all! I am trying to program a sheet to alert users when any finish date in the sheet goes beyond a specific deadline task in the sheet. I foresee it working like: User changes a start date, and several tasks down the dependency waterfall, a finish date gets pushed beyond the deadline task's date, and an error shows…
-
Adding a Checkbox conditionally
I have a condition where I'd like to have a cell blank, until anything is entered into a cell on the same row. For example, if Column 1 is blank, there is no checkbox in Column 2. If any data is entered into Column 1, add a checkbox to Column 2. The difference being that if Column 1 is blank, and data is entered into…
-
Conditional Formatting to apply color to a cell with value after comparison
I would like to automatically apply color to a cell based on its value, as compared to another cell. I have a budget target in a comparison cell, and have a the budget actuals in the cell that needs to be colored in either red or green depending on it being above or under/on budget. Is that possible? I tried entering…
-
Conditional Formatting
Hi all, I have a sheet which has approx 55 columns, with alot of different data on, i need to set up conditional formatting to colour a cell yellow if it contains "TBC". I know i can set conditional formatting, but its a long and tedious task to do it per column. Is there a way that i can set up conditional formatting for…
-
COUNTIF/AND/THEN CHECK A BOX OR SYMBOL
FORMULA 1-I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
