-
SUMIFS question
On one of my sheets, I am summing a range based off of another columns date range and another columns value (true/false). Currently, the formula I am using is: =SUMIFS({JOBS AWARDED Lighting}, {JOBS AWARDED Bid Date}, AND(@cell > DATE(2020, 1, 1), @cell < DATE(2020, 12, 31)), {JOBS AWARDED Range 4}, @cell = 1) However,…
-
Automatically adding rows to sheet and automatically nesting them under parent row?
Is it possible to have a rows automatically added to a sheet (for instance from a form on another sheet), and have the rows automatically be nested under the correct parent row on the target sheet? For example, if the Primary column is "project name", and "parent project name" is a field on the form, is there any way for…
-
Date format
I am trying to pull a project start date out of a field. The project field shows the date as: Column name: Project Name Data in row: 20201219 Project XYZ 69278 Where the first 8 is the start date of the project (20201219 in the above example) Then the name (Project XYZ in the above example) Then the Project id for accounts…
-
Can I reference a range of cells to select from?
I have a sheet for people to enter their time on. When they select a job number for their times from a drop down list, can the next cell give them specific "phases" for that specific job to select from? This is a snapshot of the record of the time: This is a snapshot of the sheet that describes the phase:
-
Can I add the number of check boxes together to get a number?
I have 8 check boxes I need to add together to ultimately get a percentage complete. E.g., if 8 boxes are checked, 100%, 4 boxes checked, 50%, etc... Here is a screen shot of the formula I built so far, but it's incorrect:
-
If Formular
Dear Expert, I need help on below formular. I try to get a column flagged, if this 2 arguments are fullfilled: Factory column is "Yes" and and status is "Released" I tried this:=IF(AND([article creation date]@row = "Released", [Dev Factory]@row = "Yes"), 1, 0) But it shows also a flag if only 1 part is fullfilled. Where is…
-
Count/sum only if one of children is a specific value and scope
Hello everyone, I was wondering if someone can help - I would like to do some financial departmental metrics in terms of revenue. Now, I have a sheet with about 300 different projects and would like to create another sheet where I will only see the sum of the revenue/totals for each of the 3 columns (as below). My costs…
-
How do I get my workflow to work?
Hi could anyone help me with this work flow? Firstly I wanted once a row was complete, it would delete, however i read through some of the comments and showed that this was not possible. Instead I wanted once the row is complete, to move into a separate spreadsheet, however the work flow isn't working. Could anyone help?
-
Countif formula
Hi, I am building a formula to count the number of cells in a column that have a given value. =COUNTIF(Status:Status, "In Progress") The cells in the Status columns have a vlookup formula. The countif formula does not work as it seems to not read the value of the cell but the formula. It was working before I added the…
-
Predecessors #ref formula
I am building a template which requires users to delete un-required task rows. This then creates #REF in the predecessors box (along with the other predecessors) I would like to highlight the predecessor box containing #REF but i cant get a formula to identify the data
