This discussion has been merged.
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
I have a sheet with a status column. I would like to have the statuses in that column automatically updated based on when users make their updates in three other sheets. I thought I could use a workflow but I don't want to update the full row from sheet to sheet, only the cells in the status column. What is the best way?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
In Sheet 2, I am looking to search Sheet 1 for an instance of a value, that could be in one of four columns. Sheet 1 COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | ABS 123 | March | 26444 | | 43454 | ABS 456 | June | 87834 | 45003 | | ABS 789 | August | | | | ABS 000 | October | | | 36543 | There are four order…
嗨内容社区,我有一个column of data with cells that contain text values that I need to count. For example, the cell in one of these columns may contain something like: "ABC123 - TEXT TEXT TEXT ABC008 - TEXT TEXT TEXT" The two lines of "ABC" text are separated by a carriage return. I'm trying to count how many…
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
Hello! Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off. =SUMIF([Open By Year]38:[Open By Year]43, @cell < TODAY(), [Total Units Signed For]38:[Total Units Signed For]43) - [# Open]@row…
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
