-
Accounting Workdays
Hi all, This question has probably been answered in various forms before, but I couldn't find the solution: I would like to show a column the accounting workday. Last weekday in the month = Workday 0. All weekdays after that would be 1, 2, 3 etc (weekend do not count). All weekdays before that would be -1, -2, -3 etc. Is…
-
Changing a symbol based on the data in 2 columns
Hi, I am trying to have a symbol column change based on the data in 2 columns. Column a is The proposed finish date of the task - Called Finish and Column b is the % completed of the task - Called % Complete. I am trying the following with no luck, but as i am relatively new, this is not surprising TBH. =IF(Finish@row,…
-
Change Counter Function
Hi, I'm trying to track how often a cell changes value, is there a way to make a counter go up 1 every time a cell value changes? I would like the counter to be a cell in the same column as the cell i'm tracking changes. I can see the history of the cell by right clicking | View Cell History, but can't use that to pull to…
-
Index Collect/match formulas / automatically update
Hi everyone, I'd like to have a formulas which reports what we call "Cost Center" from one/multiple sheet into a Year Planning sheet. I need the formula to give me the "Cost Center" if a cell is matching the name of the collapse one (category) above it. Source sheet (Master Sheet NL) : Year Planning sheet : My formula :…
-
Contains function
I am having trouble with a formula that contains multiple "If(contains)" function. The following returns unparsable. =IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS(“54”, [Account #]@row)”54”, "")))
-
COUNTIFS with Checkboxes and between Date Range
Hi everyone! So I need help again and hoping someone would be so kind as to help me. I need a COUNTIFS formula that will count the number of checkboxes checked, if a date column is in a certain month. I have found out to count the number of actions by month, but because of different criteria I need to count the checkboxes…
-
Cancel this. It's working. Long day.
=COUNT(COLLECT({Initiative}, {Initiatives Target Qtr}, $Label$10, {Product Category}, " ")) I'm trying to count those with a an empty Product Category cell in a particular quarter. I get 0 every time even though I know there are 6. I've tried changing the order, no difference.
-
Harvey Ball Color
Hi - How do I change the color of a Harvey Ball? Rather than RYG, I'd like Blue, Pink, Green and Purple. I do not need to tie the color change to any other field. I just want to change the color, as the traditional RYG don't correspond with my workflow.
-
Metric SUMIF Formula with multiple criteria (dropdown box and checkbox)
I am wanting to build a metric from a sheet using multiple criteria. I want to sum the Amount Expected of all Types that are "A&D Fee" and are NOT checked as Received. I've attempted this formula and am sure I am missing something. The check box variable is throwing me off and I'm not sure if the formula start with an IF…
-
MATCH MULTIPLE CRITERIA ACROSS MULTI-COLUMN RANGES RETURN VALUE FROM ANOTHER COLUMN
Hello, I am trying to look up an Employee from one column on one sheet and match it from a range on another sheet. Once matched, need to look up another specified criteria on another range which looks at the same column # in an identical column count range. Finally, look up another specified criteria at the same column #…
