-
How can I apply a formula to a whole column
We have a webform populating a sheet. (See screenshot) We have formulas set up on the additional 3 columns but they don't populate when the webform is submitted. At the moment, we have to drag the formulas manually. Is there a way I can apply the formula to the whole column?
-
Lookup() returning #NO MATCH when it is definitely there
I have created a new sheet to store the priority values of my ticketing system so if I change the values I don't need to change all the formulas on my main sheet. It's used to determine when to set the due date. It works fine for Low and normal, when I change the values it changes the due date correctly, but when I select…
-
Automate Status Based on Due Date and Complete Date
I have a status column that uses the Red, Yellow, Green, and Blue symbols. I would like it to automatically update based on the dates in the Due Date and Compete Date columns. The parameters are as follows: If there is a Complete Date = Green If there is no Complete Date, AND Due Date is over 7 days away = Blue If there is…
-
IF / AND Function for Checkbox
Hello, I am struggling to get a formula to work. I have a sheet tracking vehicle hours. (hours updated automatically through API feed) and would like to have a check box selected if the vehicle hours fall within a range. (the range is between 4900 & 5000. (each row is one vehicle) My formula is =IF(AND([Meter…
-
With checkbox column, how do I automatically check the children when the parent is checked?
I have an automation that sends completed projects to a new list when the completed column is checked. I want to make sure the children rows move with the parent row without having to check each individual child. How can I create a formula that automatically checks the column of the children rows when the parent row is…
-
Do shared users need access to other sheets from which cells are linked?
We have a sheet which pulls most of its data via cell link. We do not want to provide access to the reference sheet to the shared users. Will they still be able to see the data in the sheet we do share with them, or is it like a report where they would need access to the reference sheet? Thank you!
-
COUNT IFS for Assigned Person
I want to count the number of tasks due within a certain time frame, let's say next 7 days. I have found the following formula to work: =COUNTIFS([Due Date]:[Due Date], >=TODAY(), [Due Date]:[Due Date], <=TODAY(7)) However, I now want to expand the formula so it is only counting the number of tasks due that is assigned to…
-
Generate new row when box is checked
Hello, The sheet I'm using is the back end of a sign-in form for my office. The user selects the week they want to come in and checks a box next to the days of the week. I then have a series of formulas that will turn the checked box into its corresponding date. What I would like is for each of those dates to show as its…
-
Multi-Year Formula
Hello All, I am new to formulas on SS and need your help writing the following formula. In the first (non-primary) column is a date field. (E.g. 3/9/2022) In the second column I need the first col date + 3 years to go all the way down my spreadsheet I am sure this is simple, but I need your help!
-
Combine 2 Index Match formulas to concatenate 2 cells?
I have 2 sheets, each with a column for Subcontract Codes and a String of all the jobs they have worked on. Sheet 1 lists jobs that we had positive experiences, Sheet 2 lists jobs we had negative experiences. I need to combine the job numbers into a 3rd sheet, matching based upon the Sub Codes. I can easily get one list of…