-
Alternating Row Colors
Hello, I am trying to format my entire sheet with colored rows that alternate. The Excel formula that perfomrms this is : =MOD(ROW(),2)=0 This would be an awesome feature but I can't seem to fiund anywhere in the UI. Thanks for your help.
-
MAX? IF(S)?
Hello! I'm trying to figure out a formula to return the highest value from a range as long as it matches certain criteria. In the screen shot's example-- I want (in column 'Highest Day Late') to return the value of the highest past due date based on the range only if it includes the name from the Primary Column. Please…
-
Attempting to convert data from check boxes to Multi Select Dropdown
Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that the Multi Select Dropdown is an option, we would like to migrate that data over to a…
-
Health Check Formula Error
I am attempting to create a Red, Yellow, Green, Blue health check based on a Status Column and Planned and Actual Dates. I continue to get an #UNPARSABLE error message on below. I have checked, spelling, quotation marks and I can validate every logic function except the first =IF statement. Thought it was a ")" issue, but…
-
Single-Select drop down menu autofilling options
Hi, I am attempting to select an option from a single-select drop-down that will auto-fill the next column. I have loaded the formula as a one to one basis, i.e. if 'this person' is selected, populate 'this manager' in the next column. However, I need it to be across multiple employees. So if, this person, this person, or…
-
HELP writing a multi-variable IF Formula
Looking for some help with automating a Health column with Red, Yellow, Gray, Green balls based on 4 corresponding values in a Status drop-down. But there are also some overrides that I want to incorporate and can't figure out. Back Log = Gray In Progress = Yellow Flagged = Red Complete = Yellow Override 1 Marking…
-
Problem with nested IF statements
I'm having a problem with the following statement. Each IF statement works independently, but not when nested. Can't figure out what's wrong. =IF(AND(Budget1 >= 100000, [Executive Sponsor approval2]1 = "Approved", [Finance Approver approval]1 = "Approved"), "Yes", =IF(AND(Budget1 < 100000, [Executive Sponsor approval]1 =…
-
IF formula with allowable variance
I need to write a formula that will put Yes in the column if the Quote and Invoice values are within $5 of each other, or if the Quote Frequency is recurring. Here is what I have so far, but I can't figure out how to add the allowable variance of $5 =IF(OR([Quote Amount]13 = [Invoice Amount]13, [Quote Frequency]13 =…
-
Formula Help
I'm trying to calculate how many days the process takes. I want to calculate the days from "Date Request Received (LAW)" to "Date of City Council Decision". If "Date of City Council Decision" is blank, I'd like it to use today's date. I can't figure out where I went wrong. Thanks in advance! =IF(ISBLANK([Date of City…