-
RE: Percentage
Hello am seasons greetings. I am trying o calculate percentage but if its less than 1% its not providing the correct answer. The formula I use is: =IFERROR([# Patients Developed Extravasation]@row / [Total # Patients Received IV Chemo]@row, "") See screenshot of columns I used. Any help would be grateful.
-
How to highlight a partner when a value is reached
Hi Team, I was wondering if anyone has an idea how to highlight a cell when a partners reward value exceeds a Dollar amount? I currently have a sheet that is updated from an external source on a fortnightly basis that shows clients invoice values. From this data I have a formula that calculates a reward amount on the sameโฆ
-
Status Indicator formulas
I have been working on this for two days and I finally decided to ask for help. I am trying to achieve the following: If Dev Progress is marked as "complete"ย then "Blue" If Dev Progress is marked as "In progress" andย Today is between Start date and End date then "Green" If Dev Progress is marked as "not started" and Todayโฆ
-
If this, then that formula question
Hello! this may be so simple, but I'm having a hard time with it. I want a few things to happen - if the Approx trips per year is blank: provide the sum of just the Registration price field & the Approximate travel field If the Approv trips per year is NOT blank: multiply the approx trips per year by the apprx travel cost,โฆ
-
Best formula to use, maybe VLOOKUP
Hi! Need some help. I'm hoping to describe my issue the best I can.... I have created a form that end users will complete. Based on information in the form, I will need to move the row to a new sheet. I have over 400 sheets (each sheet represents a store / location) and I didn't realize that you are only able to have 150โฆ
-
Send to Contacts in a cell VS Send to Specific People
I created a form and want mulpile people to be able to submit a request. Once the request is approved I want the person that send the request to recieved the notification that is was approved. The only option that I see is " Send to Contacts in a Cell" and "Send to Specific People". I don't want everyone that submitted theโฆ
-
Formula Help Needed!!!
I have a formula that works for when a finish@row date is less than the specific target date (Finish21) and the Status is not in (In Progress, Not Started, or At Risk) than the cell count should be 1. However I'm struggling with adding the function to this formula that states IF the Finsh@row is Blank than the count shouldโฆ
-
Calculate Manpower Needed for month based on different interval schedules
I'm trying to calculate the total "Monthly Manpower Needed" for several lines that have different intervals. So every item that has 30 days listed, I want to calculate (time X manpower), for 60 days I need (time X manpower) *.5, for 90 days I need (time X manpower)*.33. Right now I'm using a filter and just plugging in theโฆ
-
SUMIF w/ Negative numbers
Hello, I got a quick question for you amazing people. Long story short, I'm trying to create an attendance tracker that tracks things like tardiness, call outs, pto, fmla, and overtime. I feel like I got something substantial, but I'm missing a small component. So the idea is that we track all these different occurrencesโฆ
-
Getting top-level heading's rank
I'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first top-level heading, make it green. If it's under the second top-level heading, makeโฆ