-
COUNTIF for dropdown column AND multiselect column
I am trying to count the number of times a variable shows up in a column that has both a High impact and is assigned to Department A. an example of a table would be as below: Project 1, Department A & Department B, High Project 2, Department A, High Project 3, Department B & Department C, Medium I tried using the following…
-
Invalid Data Type Error
Hi All, I created a metric sheet for my Dashboard with a section to count how many store openings I will have in 2024. The formula is sourcing my Summary Sheet. I entered the following formula into my cell: =COUNTIF({Summary Sheet Range 2}, YEAR(@cell) = 2024) Any ideas on why it's throwing an invalid data type error? Both…
-
Help using sum if along with collect function
Can you please review my formula and tell me what I am doing wrong? =SUMIF({*Capital Sales Pipeline Range 6}, "Yes", {COLLECT({Sheet - Sales Pipeline Range 2}, {*Capital Sales Pipeline Range 5}, "Won"))
-
Adjusting Threat Level Formula
I have a formula to set the threat level based on my status and milestone date. =IF(AND([Percent complete]@row <> 0.3, TODAY() > [Current milestone date]@row), "Red", IF(AND([Percent complete]@row < 0.3, TODAY() <= ([Current milestone date]@row + 30)), "Yellow", "Green")) I want my status to be green when the course status…
-
Combining (if and) with an IFERROR
I am trying to combine two statements. The original IFERROR statement works fine. I want to evaluate my duration column (milestones) and if duration is 0, then I want to simply evaluate baseline date - start date and put a specific value in the cell. =IF(AND(Duration@row = 0, [Schedule Delta (Working Days)]@row = >1)),…
-
What formula should I use to create a basic health assessment?
I am trying to create a health risk assessment for this particular template in Smartsheet. For some reason I am getting the unparseable error code. I want my team to be able to look at this form and see colors that represent where we are at and what is at risk for being "overdue" based on the end date. Green is good,…
-
looking for an efficient way to calculate the number of weeks
Is there a more efficient way to calculate the number of weeks between a start date and an end date without using intermediary steps or an extra column? Currently, I use a formula to find the difference in days between the two dates and then divide by 7 to get the number of weeks. I'm wondering if there's a more direct…
-
How can I copy parts of one sheet to another
Good morning! I am hoping someone can please assist me. I have two sheet. Sheet A is a Master Staffing Roster PM's maintain. They use this everyday. There are times when information from the Master Sheet needs to be inputted into Sheet B. Rather than the PM's typing it out I would like to automate it so only specific cells…
-
Networkdays formula syntax error
I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
-
indicate yes/no if date is between dates
I'm trying to incorporate a simple indicator on whether or not a task was completed within the appropriate timeframe. the timeframe is +/- 30 days from the date due column date. I've tried a number of formulas and none of them seem to be working and I can't figure out why. Is it because the earliest/latest dates possible…
