I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but wh…
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can us…
Hello, Could anyone advise on how to print a readable gantt chart in A3 format? I've managed to export it to PDF and select the rows needed, however it is barely legible. Exporting to excel has not he…
Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most …
Hi! I have some grumpy developers with a HUGE ask, likely impossible, but at the very least difficult. If it is easy then roll it out! Have better cel controls where only Text is allowed, or only a re…
Minus opening each sheet, report or dashboard a deactivated user was "shared to", looking for a more efficient way to find (and/or remove) their email from any 'Automations' and/or recurring 'Send as …
I wanted to share a Formula / Method for validating ISBN numbers since I didn't see any discussions or suggestions on how to go about, I thought I would make a post here for if anybody wanted it or ha…
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings …
Hello, I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank. The formula currently being used is: =IFERROR(INDEX({Portfo…
Hi all! I cannot seem to get my IF AND statement to work and would sincerely appreciate some guidance! I am attempting to alter/update a cell on one sheet that acts as a matrix for employee training w…
