-
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…
-
Help with multiple IF formula
Hi, I am wondering if someone can help with a formula please. I have two date columns which lookups to a cell and gives it a start date and an end date. Which is usually a start of the month and end of the month date. I need a formula that looks at 'Date Completed' and if it is within the start date and end date then it…
