-
COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank
Hello, I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard). I need to count blank cells in a specific column, but only if another column has text. I'm using this formula: Where Range 1 will indicate if a new submission has been…
-
Formula for sum of values in columns of other sheets per collaborator. Cells assigned to "nn".
I have a summary sheet "Summary Sales" created from another sheet "ADMIN_2020" in rows 2, 3 and 4 of the "Summary Sales" I have 3 employees assigned. And I need to do the sum of the entire column (NETO column) from ADMIN_2020 for each independent contributor. Who can help me will be very grateful. regards
-
Formula to capture data in a cell on last day of the month.
I'm trying to figure out a formula that will capture the data ($) that is in a cell (on another sheet) on the last day of each month. Is this even possible? These are items that will move/change frequently so I just need to lock in the numbers at the end of each month and would prefer it to not have to be manual. Can…
-
How to save a formular if i export the table to an excel file?
Is there a way how to save or export a formular, so that i can reimport the (excel) file for an oncomming use?
-
Formulas not showing in new rows
Hi, Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it. The first attachment shows how the sheet is setup and a number of columns have formulas in them. If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down…
-
TRYING TO RETURN THE DAY OF THE WEEK.
trying to get the Day of the week (ie. Mon, Tue, Wed) to return based on a date column. Tried this, but getting and unparseable error - what am I missing? =IF(WEEKDAY[Bid Date] = 1, "SUN", IF(WEEKDAY[Bid Date] = 2, "MON", IF(WEEKDAY[Bid Date] = 3, "TUES", IF(WEEKDAY[Bid Date] = 4, "WED", IF(WEEKDAY[Bid Date] = 5, "THU",…
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in. The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list. Has…
-
Nested If/And but need and And/Or
I am trying to have the Opportunity Status ball automatically turn green when the four columns to the right are Green OR Gray. I can get the formula to work with just "Green", but when I try to put the OR "Gray" into the formula, it results in a yellow ball or unparseable. =IF(AND([Commercial Business Case Completed]1 =…
-
How to pick the latest date from Table 1 and enter it to the cell of Table 2?
Table 1 is a list of products that contains among others columns Trade Name, Country, Crop and Last Modified (Auto). Within the rows, one trade name can refer to different countries or crops. In Table 2 there are only Trade Name and Date columns. I need to choose the latest date from the rows of Table 1 referred to the…