-
How to write a formula if then formula with multiple conditions
The formula I am looking for is if a PO Amount is greater than 50,000 then return a circle but if it is greater than 100,000 return a square and if it is less than 50,000 return a triangle. I have tried =IF([PO Amount]@row <50,000, "triangle", IF[PO Amount]@row >50,000, circle, IF[PO Amount]@row >100,000, "square") this…
-
How do I write a formula that returns a circle if a PO value in another column is greater than $100
=IF(["PO Amount"] > $10, "Circle", ["PO Amount"] <$10, "Square")
-
Visible audit log instead of "view cell history" for numerous lines of data
I know I can view who marked a check box through view cell history but I'm looking for a way to display the person who marked an "approved" or "Done" check box without all the extra clicks; I need a visible export format as an audit trail. I can't rely on the "modified by" field because we have users that go in after an…
-
How am I using this Formula wrong?
I get a "#INVALID COLUMN VALUE" error from this formula.
-
Here is a tough one - Identify Route Blackouts
I need to schedule work on a particular route. Within my records I have a column named "Route" that shows the route number. EX: 10402. I have a DATE column called "Target". I want to add a column called "B/O Check" and write a formula that will take my target date and route number, look that data up in a sheet called "MW…
-
Exclude cells with no data?
What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for WORKDAY.
-
Multiple cross references for one sheet?
Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in…
-
Is it possible to have a column only be available to be selected based on the status of another?
I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?
-
Formula to return results based on workweek not calendar week
I have this formula =COUNTIFS([EOD received]:[EOD received], "no", [Attendance for]:[Attendance for], (TODAY(-1))) It tells me how many end of day (EOD) emails have not been received by an employee for the previous day. So on Monday I check the attendance for the previous Friday, on Tuesday I check the attendance for…
-
Formula to indicate the duplicate dates
Hi, We had dates for contracts captured in 2 different systems and I want to do a compare of which contracts have conflicting information. My worksheet has the contract number, the "Expiration Date in LR" and "Expiry Date AER", and I just want to compare where the 2 dates are duplicates, to work through the remainder. I'm…