-
Complicated IF Formula
Hi, I am looking to do a formula that will let me display the red, yellow, or green symbols depending on the amount of answers are green, yellow, or red. The picture might let me explain better. The left column is Status and the right column is Constant. Only the top 3 Totals will count towards the result. Total NYIOP…
-
Submit Bottom on Sheet
Hello, I'm trying to figure out a way to give indications to doctors to save the sheet before they exit. The intake sheet can't be a form, as I have images and over 100+ lines. I'm thinking of a visual cell with clickable formula may be. I'm open to suggestions. Thanks,
-
Only show calendar text (Primary Column) if other column = X
Hi, I’ve got this Primary Column for publication in our calendar: =([Event Title]@row + ", kl. " + Start@row + "-" + End@row + ", " + [Contact Name]@row) I’d like to only show this if dropdown column ”Booking” has the value ”Verified”. If dropdown column "Booking" is anything else, I'd like the Primary Column to be empty.…
-
Reduce IF formula with OR condition
Hello everybody! Hope you are doing well. I am creating a board for a project that we are about to start and I want the symbol identifiers to be auto-populated based on statuses and blocks/defects. I was able to put together the formula below, which works, but I am sure I can reduce it with an OR condition, but I am not…
-
Is there a formula where anytime I scan a barcode it subtracts from the Quantity on hand value?
-
Formula to Extract a Full Name and Title, into Separate Columns "First" "Last" "Title"
I have a long list of full names in the "Full Name" Column. They need to be broken out into 3 separate columns "First Name" "Last Name" and "Title" Example shown in the screen shot below. Is there a formula I can use to extract this for each column? "First Name" I've been using: =MID([Full Name]@row, FIND(" ", [Full…
-
Using AVG to Calculate Average Completion Time
Good afternoon, I am trying to find the average of a column and am having problems using AVG, AVG COLLECT, etc. I am trying to find the average of "Completion Time" column. As you can see sometimes there is no data and sometimes it says "invalid data" while awaiting the completion date. I want to put an average completion…
-
I need help with a IF formula with a check box
I want to create a report of all my orders that are ordered AND verbally confirmed, but when an order is only verbally confirmed I want a star to be next to the order. I have a date column that notes a verbal confirmation. I also have a date column that notes an order date. I want the check box to check IF there is a…
-
Formula help please
Hi community - I am using this formula in the 'Planned progress' column of my projects: But it returns more than 100% when the date is past todays date (see example below). So I need to add to the formula - if today's date is after the planned end date, the planned progress should always be 100% (and never more than 100%).…
-
COUNTIFS across sheets
Hi, I am trying to pull data from two sheets into one, where it will be used to support reports. Is this syntax correct for this? I'm getting the incorrect argument set error. =COUNTIFS({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service", {2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability…