-
Inspection tracking template - functions
Hello, I am using the Inspection tracking template and it includes the following function: =COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row) I would like to measure the number of violations per room, rather than per month but I am having difficulty knowing how to change the {Date}, MONTH(@cell ) =…
-
NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
-
#Divide by zero error for AVG COLLECT
My formula is giving an error. it works fine until I try to add the month. The month calculated field is a number/text field. What else could be the issue? =AVG(COLLECT({DYS to Completion}, {Application}, [Column5]@row, {Month}, =1))
-
INDEX(COLLECT()) function to pull partial data
I'm using an INDEX(COLLECT()) function to pull data from cross sheet reference; however, is there a way to pull partial data from the reference cell? For example, the reference cell is "Molecular Division" but I only want to pull "Molecular" into the target cell.
-
Please help: Timesheet/hour tracker
I'm building a simple hour tracker and struggling with the formula. I want the formula to only produce a value when the a date (column) is = > the start of a pay period (column) and < = the end of a pay period (column). I'm combining an already working formula that takes a row total (column name is Task Total) when a…
-
Showing Totals in Stacked Bar Chart
Hi there - Is there a way to show the total values for data in a stacked bar chart?
-
COUNTIF
I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria. A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], "Parent Project") I need to add two additional criteria for the same second range. I want it to also count if…
-
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
-
How can I get specific information once its put into my base sheet, into multiple other sheets?
I have a request sheet that people will be submitting information into. Based on that information, I want one core column to be cross referenced into other sheets. Essentially that column will just be a task number, 001, 002, etc.. Once someone submits a something into that sheet that gets auto populated with the task…
-
Need help with a index matching formula or next best alternative
Hello, Our dept's role is to facilitate visitors (overseas medical faculty), who are invited by the respective clinical departments chairs to our hospital. There is a lot of paperwork involved between the host department, our dept and HR. We are therefore leaning on document builder feature. But one thing, the good…
