-
Formula Question for multiple criterion
Good Morning, I almost have this cracked: =COUNTIFS({Emp Status}, [Emp Status]@row, {Rank}, "SGT", {G-300}, ="") I want to add another Criterion after "SGT" so it can track SGT and LT, but I am coming up short. This formula only works to see all SGTs who has taken G-300, but I want both SGT and LT. Any suggestions?
-
Any idea on using OR function with SUMIFS?
Hi Smarties, I understand we can use OR function with SUMIFS or COUNTIFS - I just couldn't figure out how. I am wondering if there is a solution to the problem below "OR can be used directly in a boolean column (checkbox, flag, star) or can be used within another function—such as IF, SUMIF, COUNTIF, SUMIFS, and COUNTIFS."…
-
Hours as a % of a 40 hour work week
What formula would I use if I ask a team member to enter the hours they spent on a project (via form) and then on my sheet I want to convert this to a weekly % allocation? Thank you, Becky
-
Text Returned based on a Date Coloum
Hi I don't know if I am just unable to find the right question to ask in a search but I cant seem to find the right answer. I have Text Column called "Health" and a date column called "Date Requested" which I write the date the task came in. What I would like to do is: If the "Date Requested" is 7 days in the past I want…
-
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…
