-
Organize formulas on a sheet
Hi I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want. So question is how best to organise formulas on a sheet, is the below…
-
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
-
Formula placement where data rows are constantly changing
Hi All, I am trying to build a report or sight that captures the count of various columns based on other columns. {PLEASE add the funciontality of formulas referencing other sheets}. The count and countifs formulas work well in isolation. I can add the formula in a new column and then hide this column. The problem I have…
-
Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
-
IF formula with dates
Hi Can anyone assist with why this formula doesn't work? Ideally I would like to return a text result of "FY18" if the dates are in the range 01/07/17 to 30/6/18. Thanks in advance. Richaerd
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Search through Symbol Column
Hello, I am trying a formula to search through my Symbol Column and get back a Symbol, if there is the same Symbol in the Colums: I am now trying with: =IF([Eskalation]:[Eskalation] = "Extreme"; "Extreme"; "no Extremes") it shows me that the formula is wrong. Anyone has any idea why? I just want to have a Cell at top, that…
-
Auto-Increment Change Orders
I have a column [Entry Type] which contains (Task, Change, Other). I use a web form to allow others to enter change orders. I would like to automate naming these change orders as Change Order 1, Change Order 2, Change Order 3, etc. I can use =COUNTIF([Entry Type]:[Entry Type],"Change") to obtain the number of change orders…
-
Notification sent on selection of certain criteria from drop down menu
I have a sheet with a simple drop down menu. I have a notification set up for my accounting department. They only want to be notified once the "accepted" choice from the drop down menu is selected and not the other 4 choices. Is this possible. Thanks in advance Louise
