Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single …
I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny" if the status of the risk is "closed" and if not closed, i am using the ot…
I need to create a COUNTIF formula (I assume) that will count the number of duplicates of a number in at least 10 different columns. I will eventually create a notification for the end result but I ca…
Hello all, I am building a complex multilingual sheet that will be creating various documents using Document Builder depending on the user's choice of country and language. There are a lot of column f…
I'm using the following formula, which references another sheet to pull in definitions/text: =IF([Job Family Recommendation]@row = "Accounting Operations", {Job Family Definitions Range 5}), IF([Job F…
Please help with reviewing the formula below. I am getting #UNPARSEABLE. =IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N") If I only do the single…
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of c…
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/h…
I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must mis…