New answers tagged

0

You need to assign a value/formula to be used when the result is "-" Try this: =IF(I40<>"-",(I39-(I39*I40)),I39) I40<>"-" generates a "true"/"false" true = (I39-(I39*I40)) false - I39


0

Turns out Excel does not like A5:A. A needs to be defined. A5:A1000 will work.


0

Trello now has their own export capability built into Trello. You can access this from the menu on the right of your Trello Boards and export to CSV or JSON. For generating a burndown chart you could export daily and generate a count of the cards in your Sprint Backlog and In Progress lists. If you need to extract points data that should be possible if the ...


0

If you use an $ to fix the column letter, you can use conditional formatting to apply to the entire row based on a single column (or the other way around, if you fix the row number and base it on the top row values). So, if I want the rows in columns B to E to change colour if the value in the A column is 1, I would use the condition =$A1=1 for cells B:E.


0

Try this script. To access it, either put it in a custom menu or create a shortcut. function jumpto() { var ss = SpreadsheetApp.getActiveSpreadsheet() var ui = SpreadsheetApp.getUi(); // create variables var activeCell = ss.getActiveCell() var formula = activeCell.getFormula() var cellref = formula.substring(1) var sheet = cellref.slice(0,...


Top 50 recent answers are included