-
Reference Formula
Hello SmartSheet Community, I need a formula that can detect if a name has appeared on other sheets I've used in the past. I have a column named "Duplicate" that I would like to have automatically checked if someone enters a name under the column "Name (Last, First) that has already been entered on sheets columns labeled…
-
AND(OR Statement Help
I'm getting stuck on this one. I have a working OR statement formula based on no information from two different columns. I want to add a third variable based on another column having a specific statement. I've tried this a few ways but, nothing has worked. Working Original statement: =IF(OR([ePRG Training]@row <> "",…
-
Get the latest value of multiple matching entries.
Looking for the right formula to look at the list of entries and IF the Contract Number AND Invoice Line Item Number match. The example screenshot shows 4 lines. They're all the same contract, but the 4th line item is a duplicate entry of "A". SO I want the "Latest Contract Amount" column to keep the latest value entered…
-
Getting multiple Fields from 1 row using MAX and COLLECT
I have a sheet (IDF Check) that contains static information about my IDF's that I want to use as a kind of dashboard. I have a second sheet (IDF Checklist) that collects information from weekly checks on the IDF including Date and time checked, the inspectors name and a calculated field of the overall status of the IDF.…
-
Formulas to identify current project phase, next task due on a project plan and the task due date.
Hi everyone, To help us report the current position of a number of projects, we have been asked to report on the current phase and next due task. So I need to find formula's that can identify the following 3 things:- What is the current phase of a project. On example below, "Defined, Scoped and Analysed" is the current…
-
=INDEX(COLLECT(
Hello, I am trying to return a value based on 3 criteria but am getting the #INVALID VALUE error. Sheet 1 contains my the 3 deciding factors (Single Point of Failure?, Business Impact and/or Safety Related, Lead Time to Procure) and my desired output (Critical Spares Suggested). Sheet 2 is the user tool that is looking for…
-
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…