-
Auto send out form
Hi All Good day to you. Is there a better way to auto email form (bi-monthly basis) to a user outside our organisation? The user will be required to update the information in the form and submit it back to us. Currently, we are using "send update request" to auto email out the form Million thanks in advance Patrick
-
Late Submission formula
Hi All!! I am hoping to create a formula to alert me when a request was submitted late. For example - if a request was submitted on 10/1/21 and the request is to start 12/1/21, then the request would be marked as a late submission as the request was submitted within the 60-day deadline we set. I do want a column that would…
-
Pass/Fail status based on value of one cell being less than or greater than another cell
Hi All, Would appreciate some guidance on a formula I'm having trouble with. I would like to create a pass/fail column based on whether the value in a column@row is greater than or less than the value of another column@ row. Current Formula - =IF(CFUs@row > [Action Level CFU]@row, "Fail", "Pass") For some reason, I am…
-
Copying columns to additional sheets
Good Afternoon, I have a sheet where information is submitted using a form. When a row is added, a unique identification number is attached to that row. I have separate sheets that are used for the investigation into the incidents/hazards reported in the form/rows. I would like some of the columns to be automatically…
-
Looking for a formula to create a unique key
I'm looking for a formula such as MD5 to create a unique key where one does not exist naturally in the worksheet data. When combining two or more columns a unique value is possible, but it would be great to have an formula to calculate a representative vale.
-
countif help
Hi Folks hoping i can get some assistance I have a large tracker that is tracker COVID isolations and test results. i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard I made a Weeknumber helper column, the week number will generate if - Positive is checked and…
-
Trying to find a formula to sum a column that has
I am trying to find the best formula to accomplish the following: I have a Description column and a Totals column; I am trying to write a formula that will find the word "new" in the description column and then sum the totals column from that same row with the word new. I am truly at a loss as to where to start. Tried an…
-
If Contains Statement
I am trying to say If x column contains (a) value then display (b) value from another sheet. But it says Invalid Data Type =IF({Retained Team Look Up Table Range 1}, CONTAINS(Resource@row, @cell), {Retained Team Look Up Table Range 2}) Retained Team Look Up Table Range 1 has the same values as in the Resource column of the…
-
Having trouble with IF "CONTAINS" function
Hello, I have a column with a dropdown list that allows users to select Yes or No to satisfy the requirements of a question. If the user choses “Yes” they are then required to provide details to explain their answer. To eliminate blank cells on the sheet where the answers are recorded, I used the following formula to…
-
SumIF using AND OR
Hi, I was able to do a simple SUMIF but I need to add in ands and couldn't figure it out with SUMIF or SUMIFS. Here is what I have right now that is "INPARSEABLE" =SUMIF({Merkle - Retainer Hours Log Range 1}, CONTAINS(Resource@row, @cell), {Merkle - Retainer Hours Log Range 2}), OR(SUMIF({Gyro Retainer Actual Hours Range…
