google sheets

  1. V

    Adding two different formulas in one cell using Google Sheet

    Hi All, I have tried to merge these two formulas in Google Sheet: =DATE('Resource Matrix'!K1,'Resource Matrix'!F1,1) &" - "& OR(WEEKDAY($G2)=7,WEEKDAY($G2)=1) but seems not working. DATE('Resource Matrix'!K1,'Resource Matrix'!F1,1) is to identify how many days there is in a month...
  2. F

    Solved IF Statement

    Hi there, I can't figure out how to properly write an IF statement for this specific scenario. I have to calculate E.I (Employment Insurance). E.I is 1.27% of your gross income. If my annual gross income is for example $66'000 I'd type in the formula =(C7*1.27)/100 (C7 is the cell with...
  3. C

    Google sheets: reset several checkboxes

    As mentioned in the heading, is it in any way possible to reset several checkboxes all at once?
  4. Zsolt Kükedi

    Create a list from Google Sheets difers if it is horizontal

    Hi! I'd like to get a few cells in a list from a Google Sheets. I have the following data: First list horizontally: 1 in C2, 2 in D2, 3 in E2 Second list vertically: 1 in C5, 2 in C6, 3 in C7 Here is the test sheet: I use the following script: function onEdit(){ var...