-
Calculating costs for a task over more than one month
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, Finish = Sept 5. So in my cost sheet, the formula needs to refer to the start date…
-
Unable to delete content of a column
Hi, Has there been a feature change? I used to be able to click on the column header and hit delete and the contents would be deleted leaving the column blank Now when i do it it only deletes the top cell? Any help or comments would be appreciated Thanks Dave
-
Cell linking and updating a column
I have a master sheet that contains a column called "Product Family." This master sheet is updated weekly, and some of the Product Family rows change - added or deleted. The cells in the Product Family column on the master sheet are linked to another worksheet (called "Curation Audit") - also in a "Product Family" column.…
-
Same formula on two different sheets one works the other does not
I copied a working formula from one sheet to another sheet and changed a column setting. I cannot figure out why the column name in the formula doesn't "active". Any ideas what is wrong?
-
Conditional Logic - Setting a Value
Hi - I know a few months back Conditional Logic was added to the Forms which is awesome. I was wondering if there's anyway (that I'm not seeing) where I can use a Dropdown, Radio Button, etc. - to set the value of a Status field. In other words, If Someone Selects Option A from the drop-down, then Status 1 is set, Else,…
-
Formula (IF Statement?) that checks if row numbered sequentially?
Can I write a formula that could check if rows belonging to same project number have been numbered sequentially? My sheet tracks several projects and each project could have several entries on one sheet and these must be numbered so we know how many submissions were made per project. I wrote one to check for duplicates…
-
How to check parent row checkbox if at least one of the children row checkbokx is checked?
Hello, i am trying to find out how to check parent row checkbox if at least one of the children row checkbox is checked? Thanks in advance!
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
Help w/adding up formula totals
Hi team - I created a test sheet that I'm experimenting with various drop down menus creating scores. The drop down to score is working fine, where I have a problem is getting the "Total score" column to add all 5 scores. What am I missing? Total score formula: =VALUE([Impact score]@row + VALUE([SLO score]@row +…
-
Contains & "Invalid Column Value")
Hi I am trying to use this formula: =CONTAINS("Medium"; [Rank]:[Rank]) Rank column is the column with drop-down (single select) where user can select one of these: High (Business Critical) Medium (Moderate Need) Low (Nice To Have) However, it results in the "Invalid Column Value" error. Do you know how to solve this? thank…