I'm using the following formula to extract the name of the month (e.g., "May" if there is a "5") but keep getting an "Invalid Data" error. =IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Mont…
Hi, I'm trying to create something that will show how many projects are currently in process for an employee and, when her next availability will be to start a new project. She can only have 3 project…
Hi, I'm trying to have the status on Row 9 update to 'Complete' if either Row 10 or 11 have a status of 'Call - Scheduled' but I am getting an error. =IF(OR([Status10]="Call - Scheduled", [Status11]="…
Hi, I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked). I've tried many variations of the following formula: =COUNTIFS…
Hi, I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error. =IF({Sales Force ID} = SalesFor…
Hello, I have a report that all sheets (deployment plans) in a workspace feed into. The flagged items don't appear on the report until days after the row is flagged. Or they suddenly appear on the she…
Hi, I'm trying to count the number of sites that have PNS and are either Experiencia, Experiencia Plus or Experiencia Plus Unlimited. This formula is giving me an UNPARSEABLE error. =COUNTIFS(OR({Expe…
I need to create graphs for a dashboard that reference data from a US sheet and from a Europe sheet. The data for one graph changes when I try to reference another sheet. Is there a work around for th…
Hi, I'm trying to count the number of accounts using Experiencia with following criteria: Rounding Status is Operational AND EHR Status is NOT Operational. I'm getting an unparseable error with this f…