-
COUNTIF for multiple locations
Hello SmartSheet Community, I need a formula that will count the total number of locations in a multi-select drop-down column "Placement Location" and if the "SPAH Responsible" column = "Fred". This is what I've been using but will not add multiple locations selected in one row. Do I need to add a sum formula in there?…
-
Formula based on matching Primary Column Values
We use smartsheet for production tracking in beverage manufacturing. The primary column we use to create a batch ID for the associated production run: Date Produced + Brand Code + Run sequence (A,B,C, etc.) + Tank #. So an example would be: 03/15/21-RWO-A-01. RWO produced on 3/15, first run of the day and tank # 01. We end…
-
acknowledge receipt of update request
Can anyone thing of a way to request acknowledgement of receiving an update request? Here are the details: We are sending an update request to contacts, they have a bit of leg work to do in order to reply but we want to know that they are starting on the work. How can we ask that they indicate that?
-
Trying to pull unique values from another sheet's column
Just as the title says, I'm trying to build a solution that parses and lists the "Region Name" field in a sheet, so it can build another list based on "Regional Partner". Basically, I'm trying to build an abstract method of building a list of regions and their associated regional partners. Why? Because these 2 fields seems…
-
Creating a formula to calculate estimated hours in next 14 days
Has anyone created a SUMIFS equation that could calculate the estimated hours in the next say 14 days? Below is what I thought would work.... but it just keeps saying "0" I want this equation to calculate the estimated hours per task/child row (HC - Project header is not checked) within the next 14 days. =SUMIFS([Est…
-
How to get Month to Month Metrics by Project Phase
Hi all, I am trying to figure out a better way to gather metrics for my department's portfolio. We have 15 Project Portfolios that show various phases which we have been gathering the data manually by saving the metrics at the end of every month: 0-Request 1-Planning 2-In Process 3-Complete 4-Closed For closed and…
-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
How to get the dates for every "Monday" in a month
I am working on a Flex schedule tracking sheet for employees that would like to go into the office for set days during the month. The best way I can think to do this in a form is to allow the employee to select the days of the week they would like to work in the office from a Multi-Select dropdown. ie- Monday, Wednesday,…
-
formula not working
hi Team, I have two date columns and based on date column final status column. and applying simple formula . if (col1<=col2, "Green","Red") but in case end user enter NA in both the column, output is "Green" and col1 is NA and col2 is N/A then output is "Red".. why..? please suggest .
