-
IF(OR with RYGG
I would like to automate a RYGG column, assuming that my team is entering there own start and finish dates but due dates will be created by senior staff. Yellow=In progress Red=Overdue Grey = Not started Green=Completed So IF start date is before due date, Yellow or if Finish date is before due date Green, etc. An…
-
Getting #INVALID DATA TYPE using IF(AND and IF(OR together
=IF(AND([Logo Attached]3 = 1, [Lobby Sign]3 = 1, [Column Sign]3 = 1, Mailbox3 = 1, "Green"), IF(OR([Logo Attached]3 = 1, [Lobby Sign]3 = 1, [Column Sign]3 = 1, Mailbox3 = 1), "Yellow", "Red")) Formula above. Would like to display green ball when all checked, Yellow when some checked, Red if none checked. Can't figure out…
-
Counting overdue tasks from a lot of project sheets
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a report that shows only the tasks assigned to them from all the source sheets. Previously, we had a dashboard that showed each…
-
Add new row, calculated field not updating
I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added. When the person who will be entering data adds a new row, they are using "Insert Above" to add the row. The calculated field is not updated.…
-
VLOOKUP plus a Dropdown selection???
I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DMP". I know how to write that formula, but if the value does not contain DMP, then I don't want the lookup at all, but want…
-
If 'Submit Date' is before the 20th of current month, Set 'Payment Due' to last day of month
Hello! Creating a sheet to help with Accounts Payable process to external providers. External providers will submit their invoice and payment details into a form that feeds into this sheet. Would like the formula to determine when that invoice is set to be paid, depending on the submission date. The formula in words.. If…
-
% Complete Auto-fill / Default value 0%
Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-filled on the newly inserted row as expected (ex: At Risk flag, Project, other columns…
-
Equation help
Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different steps to each unit produced (on different lines, see screen shot), and I'm trying to figure out a way to…
-
How to use INDEX, MATCH and MAX to display newest form entry if cells match
Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry Ideas?
-
Forumula for trending up/down
Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's average is 5.10 and tomorrows average is 5.50, I need to compare those two numbers to…