-
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!
-
Nested IF Error - Incorrect Argument
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
-
SUMIF from one or more reference sheets
Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" column. Would I use VLOOKUP alongside SUMIF? Attached give you an idea of the breakdown. Thanks,
