-
Return a Contact from another Sheet based on value
Hello, I have a source sheet (Sheet A) that maintains a list of projects and assignments. I need a second request sheet (Sheet B) to intake requests. On this sheet, the project name will be included. I would like to use a formula to output the name of the assigned staff member for that project (found in sheet A). (*the…
-
Creating a points sheet from a previous query (issues with formula/sheet referencing)
Hi Everyone I have kindly had an issue relating to scoring answers on a multi-select dropdown https://community.smartsheet.com/discussion/104030/subject-adding-weighting-points-to-answers-within-a-multi-select-dropdown#latest However due to the volume of questions I'm looking to include, I want to create a separate points…
-
How do you enter a long formula?
Hello, I have quite a long formula, I wrote it in Word... When I copy and paste, the cells used in the formula are not highlighted, so I think the program doesn't recognize them. Therefore, I am copying my formula by hand. However, when I am at about the second or third line and I click on a cell to use it in the formula,…
-
Formula help
Can someone help me with a formula that would produce the hand keyed results in "Unique ID"? I want to produce a unique ID in sequential order for each record that "Job #" and "Part Mark" are duplicated. I've tried several Countif statements with no luck. =COUNTIFS([Part Mark]@row, [Part Mark]1, [Job #]@row, [Job #]1)…
-
Countif containing a specific word in another sheet
Hello, I am trying to make a countif function to extract the number of times a specific word is presented in another sheet. Some other criteria (Like the year has to be 2023) exist. So far, what I have is this: =Countif ({sheet range}, HAS(@cell, [the word I'm trying to find]), [Year range in sheet range], "2023") I can't…
-
Trying to use JOIN, COLLECT, CONTAINS, in cross sheet formulas
I've reached a stalemate in my cross sheet formula and can't seem to get it to pull in all instances that I want it to. I am attempting to look at two different sheets where either may contain the project number (TD Number), and have the corresponding BAR SME Engagement values returned. =IF(HAS({WorkOrderID}, [TD…
-
Is it possible to create a trigger from an Update Request?
We are trying to create an automation where every time an update request is sent and submitted (even without any change), an email is sent to our personnel. What is happening is that for that to happen we created a trigger where specific cells when changed send the email to our personnel. The problem is that when a change…
-
Formula with date, days and checkbox criteria
I am trying to return a date based on several criteria. IF PSA/Lease Executed box is check, then use PSA/Lease Target Date + DD Period days IF PSA/Lease Executed box is unchecked, then use PSA/Lease Executed Date + DD Period days Here is what I tried but it is not correct. Can you tell me what I'm missing? =IF([PSA/Lease…
-
Sum formula with multi select option
Hi, I am trying to create a column formula that will add up the cell values to the left based on specific drop down. Point is given if they followed these areas. So, no point would be Safety Concerns (0 pt). =SUM([Following Policy]@row:[Delay In Patient Care]@row, =[Following Policy]@row:[Delay In Patient Care]@row) How to…
-
Trying to reference an inspection date collected from an inspection form archive sheet.
I am stuck on a formula that I am trying to utilize in a roll up sheet to display the most recent inspection date that was submitted using a monthly inspection form. =INDEX({Inspection Form Sheet Date Column}, MATCH(MAX({Inspection Form Sheet Date Column}))) I have tried several variations of this formula, any ideas what I…
