-
ISBLANK formula not returning data when cell is blank
I have an automatically generated date column in my sheet 'Created Date'. I want to be able to override this date with a manually entered date 'Manual Date'. I created a new column called 'Inquiry Date' and am using this formula: =IF(ISBLANK([Manual Date]@row), [Created]@row, [Manual Date]@row) I want the formula to pull…
-
Formula to Select Multiple Dropdown Options using Two-Column Criteria
Hello, I am looking to be able to auto-populate the pending permits based on the empty date cells where we input our received dates. I currently have to manually choose what permits are missing, but am hoping there is a formula I can use to show both missing permits. Below is what it currently looks like and after that is…
-
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?
