-
Referencing Other Sheets & Summing Text & Checkboxes
Hello Again! I am looking for the formula to sum text and value, but from another sheet. I tried using a previous formula that you guys helped me with but I can't get it to work. I need to count the number of LM techs, Sub techs, and teams for a given job. The formula in the highlighted cells should return the number of…
-
Count unique values if a criteria is met
Hello, I tried to look to questions related to this, but honestly I don't understand the logic. I need to count the unique values of the column "Supplier Name" only if they have an "Owner" assigned.
-
vlookup with id and date range
Hello: I am super thrilled that I have mastered a formula that originated in Ecwid, used zapier to populate a smartsheets and then with a sumif in my smartsheets row I matched the participant id and date range to plug a payment in for a participant in our program. I want to pull the associated payment number/Ecwid Id into…
-
COUNTIF and VLOOKUP?
Good afternoon everyone, I hit a bit of a snag and I am curious to know if I may get some help. I have a tracker that we are using Smartsheet for and based on the type of item that is added in, only certain check boxes are required to complete the work. Originally I had done a massive COUNTIF formula where I had typed up…
-
COUNTIFS Based on RYG with Multiple Criteria
A colleague and I are trying to create a sheet summary that counts each of "Red", "Yellow", and "Green" statuses. The formula we've tried to use for this is as follows: =COUNTIFS(DMA:DMA, "St. Louis, MO", [2020 Reimage]:[2020 Reimage], "Y", [Ext. Paint]:[Ext. Paint], "Green") However it returns either a #NO MATCH. The…
-
Pull data from other sheets located in other workspaces
I need to gather data from project sheets located in the project workspace to the portfolio update sheet in another workspace. I was hoping I could do that automatically. Control Center is not available at this time. I can set it up within the workspace for the project dashboard. I need to get the data over to the…
-
Formula for COUNTIFS function with multiple criteria
Looking for help with my COUNTIFS formula for my sheet summary... I am trying to count all instances of the value "Mega" in the "Deal Size/SET Level of Support" column when the "Status:" column is any of the following "In Progress", "Proposal Presented", " Proposal Presented & Shortlisted to Presentation Stage",…
-
Cross Sheet Sumifs Formula
Is there a way to run a formula from a cross sheet, that would pull specific names that are in the same cell. To formulate a group that worked together total revenue by the accounts that have "closed won"? I have more than one account holder at times per account =SUMIFS({Sheet - Forecast Amount}, {MSS Sheet - MSS Account…
-
Formula Help
Hi everyone :) Each year there is a new summary sheet for data reported, in that year. The formula I am currently using has in between dates, and i would like it to recognize the quarter's column If it says Q3, and the refrigerant type is R404a, then it counts 1.. and so on. Currently their is 11 for this quarter. What I…
-
Calculating available hours based on multi-select dropdown
Hey all, I'm working on building out a scheduler for people; on the signup form, they have options like: Monday 8a - 12p Monday 12p - 4p Monday 4p - 7p ...and so on through Friday, plus some Sat/Sun weekend shifts. What I'd like to do is calculate the Total Available Hours and use that as a reference point to pull from…