Basically, I want to know all the Issues for the 4 stars groups. Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue]) But I want to say, all Colorado groups have (…
I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be e…
I am having issues with getting this formula to work: =IF([Latest comment]:[Latest comment] <> "", INDEX([Latest comment]:[Latest comment], MATCH(MAX([Notes Last Modified Date - Helper]:[Notes Last Mo…
Hello! I am trying to have the have the status show as green when something is in progress, even if it doesn't have a start or end date. I only want it to turn yellow or green when there are end dates…
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying t…
Hi, I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager). When joesmith@email.com is one of the emails in the On-Site RA(s) field,…
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this …
Hello! I am trying to make the following formula. If "Actuals (Cash-In-Hand)" is greater than "Budget" list the overperformance difference in "Over-Performance". If there is an underperformance it sho…
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know…