-
Nested Multiple IF
I have a formula I am trying to work out using multiple dropdown menu options that add different formula instances. I am trying to use multiple IF statements, but I am getting an unparsable error. Here is the formula, the dropdowns are 4 options LVL2 RBH, LVL2 OOH, LVL4 RBH, and LVL4 OOH. Note - IF I use only the first IF…
-
Help with SUMIF function with data from another sheet
I used this formula to set the range, the criteria and then the sum range but it is returning zero. The range is a different column than the sum range. Any advice? =SUMIF({SSS Range 3}, >"12/31/2017", {SSS Range 3})
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Formula issues
Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue". What I am trying to achieve is count how many times in…
-
How to delete referenced sheet formula
Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X). Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there any way I can clear these out? Please help.
-
Pulling text through from other sheets
Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a risk that....) and a risk score (5). I understand cell linking but this won't work as the top 5 risk and issues will change on…
-
Formulas Across/Within Sheets
Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many…
-
Business Days
Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!
-
Looking for Formula
Based on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be greatly appreciated.
-
Referencing External Sheet Data
Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. Is it possible to type in an asset tag and have the corresponding serial number auto-fill in the adjacent column? Thanks!
