-
Attendance Point Tracking - Referencing a previous entry
About a year ago, I threw together a janky system to keep track of employee attendance. The idea is that there are different point values assigned to each kind of attendance occurrence, which the points fall off after a year. However, we have added a twist that is throwing me for loop. We now have a policy where if they…
-
What formula can I use to return a value if the value is in between 2 dates?
Hi! I have two sheets. Sheet #1 is a support schedule with columns for every day of the schedule, each column is a dropdown menu column. I extracted the date in text form for each day as shown in the first screenshot. For each day we have different resources assigned in a different column. In sheet #2, I want to have my…
-
COUNTIF formula returning 10 extra blank lines
I wrote a formula to count the total number of unassigned purchase orders in my sheet, which looked to be working at first glance, but upon comparing it to the actual data in the sheet, realized that it is counting 10 ghost orders. This is my formula: =COUNTIF({Assigned}, ISBLANK(@cell)) The Assigned column is a contact…
-
Why is my SUMIFS formula saying incorrect argument?
I'm working on a metrics sheet to power a dashboard. I want to sum our effort values for each of our chemists and each of our project categories. My ranges are: {MasterLead} : Column listing chemist on project {MasterEffort} : Column of effort values for each project {MasterRDCat} : Column of project categories I am trying…
-
Use of sheet summary fields (or formulas) in automation
It would be great to be able to include calculated values and/or sheet summary fields within automation. In general, the point is including global conditions in the automation criteria. An example is an employee calendar with daily alerts as to who is out of the office. When people are out for a range crossing a…
-
Formula Query
Hello, I want to feed a sheet automatically as we could do on Google sheet with the Query function. Is this possible with formulas? for example I want to highlight a whole column from sheet 1 in a new sheet 2 based on a criteria from sheet 1 Cordialy, azerty64
-
Possible to multiply all cells in a column by a value in a specified cell?
Hi, Newbie here so this might be a silly question. I have a sheet with product numbers and prices. Recently we had a price increase across all of our products. I was hoping to be able to take all the values in my price column and multiply them by 6% (the price increase). I have the 6% hanging out in a specified cell. Is it…
-
when nothing from Index/match
Hello, when there is no return from index/match, instead of marking it N/A, it randomly picks any value which making the match incorrectly. any tips? Thanks,
-
Date Formula Question
Hello, I am creating a formula to pull the month out and then if the date is blank to have the field be blank. Here is the formula I am using: =MONTH([Activity End Date]@row, IF(ISBLANK([Activity End Date]@row, " "))) However, I am receiving an "Invalid Data Type" response. I've attached a screen print. If the Activity End…
-
How would I create a formula which returns the Top 5 most frequent words in a column?
I have been tasked with creating metrics which show the current 'Top 5' most frequent countries in a column. I am struggling to create a formula which returns the correct value as new countries will be added to the list in future so COUNTIF would not work. So imagine the column read as follows: Germany France France…
