-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
isFormula function.
I would like a way to determine if a cell contains a literal value or a formula calculated value. For example: On a project sheet we have multiple date fields for different actions to complete on the same item. By default we use formulas to generate estimates for all the date columns. Some users may enter an actual date to…
-
Completed Tasks Past Due Date
I am trying to make a column with stars that is starred when a date is filled into the completion date column past the due date. The only problem with this is that we have a recurring maintenance sheet, and there is a formula for the Due Date column that automatically populates it based on the last completion date. So…
-
Lookup if date is between 2 dates, then return an associated value (same sheet)
Hello:) Is there a way to lookup a date, determine if it falls between 2 dates (fiscal year quarters), and then return the corresponding value? ie: Date: 1/29/2016 Fiscal Year Q1: 1/1/2016 ~ 3/31/2016 Fiscal Year Q2: 4/1~June 31/2016 etc So, the formula would check to see if {date} (1/29) is between 1/1 and 3/31, or…
-
Formula Help please
i have a column titled # Wins and wound up with a percentage towards my Wins goal. That said i want to use RYG lights based on how close i am to the goal. So here's what i wrote but i know i'm missing something. Any help would be much appreciated. =IF([# Wins]5<=.66,"Red",IF(AND([# Wins]5>.66>.9,"Yellow,IF(AND[#…
-
Match Two Entries from Two Separate Form Sheets, Assign Status
I have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated number from the "Assignment" form to reflect the production done for that assignment. I'd like have a RYG ball on the…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
Circular Reference Issue
So I have two fields I am trying to create a formula. The first field is Today's Date, in which it is autopopulated with the current date. I have a second field name Calendar End Date, I am trying to create the formula in this field. What I am trying to do is create a check that if Today's Date is greater than the Calendar…
-
Summing of colored "conditional" cells
Hello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition not met cells? There are 25 cells that have conditions in them.
-
Nested IF Then And Statment
I am trying to finalize a Nested If Then /And Statement. In one of my logical functions, I am trying move to the next condition if a cell has a date input into. When I try to use the logic if cell > 0, it returns an error. What would be the best method for moving the formula to the next logical statement?
