-
Join/Collect Multiple Columns to One Cell WITH Column Name
I'm trying to combine data from multiple columns across a row into one cell in that row that I can zap to another program. I'd like for the information from each column to be preceded by the column name. (Example "Column Name: Column 1 Data, Column 2 Name: Column 2 Name: Column 2 Data, etc.) I've figured out how to collect…
-
Get words based off a conditioning format colored cell
I have a status column that is already created to generate a color based on what is presenting in certain columns. I have the colors red for denied, green for approved, and yellow for pending. I want to have another column that is the status words of approved, pending, or denied based on the conditioning formatting colors.…
-
worflows not working anymore today
Hi, I've set up some basic workflows on a sheet (Trigger: When rows are added, Actions: Lock a row, Copy a row), they have been reliable for a long time and until yesterday evening but this morning none of them are working. I have checked that the sheet were the rows were copied was not full. When I manually copy the rows…
-
How to make a formula to count Job Openings by title
Hi, I need help creating a formula to count different job titles open. So, for example, I need to know how many HVAC Technicians are open etc. How would I go about this?
-
I need help with an IF(AND..IF(AND.. formula that I'm getting an #UNPARSEABLE error on.
I'm trying to replicate a risk rating matrix (image included) by taking the data in 2 cells (Risk Likelihood & Risk Impact) to auto-populate a third cell (Risk Rating). Below is the formula that I am using. =IF(AND([Risk Likelihood]@row = "Rare", [Risk Impact]@row = "Insignificant"), " Low", IF(AND([Risk Likelihood]@row =…
-
How do I assign a color symbol based on criteria from 2x data ranges?
We have a critical check box column (mark a task as critical) and then separately we have a R/G/Y column for task status. Critical & Status are not intrinsically linked and you can have a task in the red that isn't critical. My goal has been to have the symbol column in the parent row change based on if critical is checked…
-
Need help with a formula.
So I am trying to make a formula that encompasses 3 completion statues. So I have 3 fields that will all get marked to 100% and I want a main completion column to up date when the others hit 100%. So when Column A hits 100% then column D will be at 33%, then when column b hits 100% column D will update to 66% and then when…
-
Tasks
How would I go about creating a dashboard for each employee so they can see all their open items. I cant do a report because that means every time we add a sheet we have to add it.
-
COUNTIFS with OR - Syntax Questions
I have a sheet that has a TARGET DATE and STATUS. I want a count of rows where the STATUS is either WIP or NEW and the DATE < Today. The goal is a count of rows that are overdue. I've been trying different variations of this formula. =COUNTIFS({TARGET DATE}:{TARGET DATE}, < TODAY(), {STATUS}, or(@CELL = "New", @CELL =…
-
Using countif for multi-select dropdown + parent/children rows
Hello, Hope you can help me. I want to count how often "PROSPEC" (multi-select drop-down) is selected in the column "Dokumentation" when the parent column "Fase" is equal to "Pilot" or "Drift" (single-select drop-down). Please see image below. My formular so far: =COUNTIFS(Dokumentation2:Dokumentation194; HAS(@cell;…