-
COUNTIF Formula in Multiple Dropdown Box but Exclude a Word
I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive. If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell)) If I use HAS, it counts when Active is the ONLY item listed in the…
-
formula checkbox referencing contact field problem
I am a newbie trying to check a formula checkbox if one of two names or both names are in a contact field list. Why isn't this working? =IF(CONTAINS("Name1", contact@row), OR(CONTAINS("Name2", contact@row), 1, 0))
-
Date formula
Hi I am trying to work on a 8 week sprint and would like to show what is in say week 1, week 2 week 3 What would be the best formal to achieve this Thanks in advance.
-
COUNTSIFS does not Contain
Hello, I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below. =COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary})) The formula works until…
-
Formula to display cell content based on health status?
Hi - I want to be able to return the content of a cell (in the case of the lower image, the content in Level 0, "Project" column) if the health status is "red" in the "Overall Health" column to display on the project dashboard. Any help would be much appreciated!
-
A formula to count a series of "Health Status" in a column to display the status with the largest #?
This one is tricky. I'd like to be able to count the # of green, yellow, red & blue statuses in a column (lower image) display on a dashboard (upper image). The other tricky part is that I only want to count the statuses on the rows that are Level 0. Any help would be greatly appreciated!
-
=(INDEX(COLLECT Invalid Value Error
I am getting an Invalid value error in this formula: =(INDEX(COLLECT({Zit Zap 102621 Units Needed}, {Zit Zap 102621 Formula}, Formula@row, {Zit Zap 102621 Inv ID}, [RM Inventory ID]@row), 1)) I'm trying to bring in the RM Units Needed from Spreadsheet 2 when the Formula and RM Inventory ID from Spreadsheet 2 matches the…
-
Scoring Formulas
I'm looking to convert a process to smartsheet, but am trying to determine if there is a formula to make the concept work. Currently I have a form which asks a series of questions - each question has a single select option of "yes (description)" "no (description)" and "n/a". For each question, there is a score associated…
-
Workflows - How to remove a respondent from a workflow once they already responded
Looking for help on removing a team member from a workflow "request for update" once they have satisfied the request (aka already responded). My current workflow is a request for an update 7 days prior to a due date. Say a team member responds when they receive the request and they provide the update. Since my alert is set…
-
Formulas- Equivalent of an array?
Hello! I am trying to write a formula that pulls information from one sheet into another based on a criteria. I have successfully written the formula to work for a single row, but can not get it to repeat for successive rows. I believe I'm looking for Smartsheet's equivalent to an array. I understand that a cell range is…