-
Formula Question
I would like the column "Done" to be checked automatically if the % Complete is changed to 100%. I am using the formula below which is not working: =IF([% Complete]3 = "100%", 1) Any suggestions?
-
Nested IF Statement for Flagging Duplicates
Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff Smith Programmer Jeff Smith Designer Jeff Smith Designer In this scenario, I want a flag checked off when ALL 3 appear…
-
Looking for a formula for checked boxes xx/xx checked
I am working on a tracking type of sheet. I have 4 columns that i have inserted check marks for: D2:D301 I2:I301 N2:301 S2:S177 The check marks are great, but i would like to take this one step further and have a tracker up at the top that as an example says xx/1072 to signify how many boxes are checked out of how many…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Assistance Needed with SUMIF Formula
Hello, I need assistance with a few sumif formulas. 1) I need to calculate Documents Scanned This Month and Documents Scanned Last Month. The formula should look for the word Documents in the column called "Scanning Queue" and give me the total Scanned Quantity for both current month and last month. Below is the formula I…
-
Countifs
Hello All, Maybe somebody could help me to set up formula where not blank cells would be counted. At the moment I am using this formula =COUNTIFS({Type1}; "SIS"; {Done1}; 0; (NOT(ISBLANK{Instaliacijos pradžia1}))). I've underlined part which is not working for me. I am bit weak with formulas so it might be what I wrote…
-
Formulas Referencing Another Sheet
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running sheet more efficient. However, whenever I type the exact same formula, with the only difference being referencing another sheet…
-
Odd Behavior: New Blank Rows Created from Webform Entry
I'm wondering why the default behavior of a standard sheet is to create 10 to 50 new blank rows when a new webform entry is received. New blank sheets are created with 50 rows. If you delete 49 rows and generate a new row from a web form then the sheet will automatically create 48 blank rows to bring you back to the 50 row…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
Formula to automate Parent date
I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the correct formula. EXAMPLE Parent Date | =last date entered below Child Date 1 | 1/3/17 Child…