-
CONTAINS not working in SUMIFS formula.
What is wrong with this formula? =SUMIFS({(Template) Channel Monthly Plan Range 1}, {(Template) Channel Monthly Plan Range 1}, >0, {(Template) Channel Monthly Plan Range 4}, >=DATE(2021, 2, 1), {(Template) Channel Monthly Plan Range 4}, <=DATE(2021, 2, 28), CONTAINS('"Victoria Scholly",{(Template) Channel Monthly Plan…
-
CheckBox Formula
Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF(Done@row = 1, "Complete")…
-
if / and / isblank formula
If my status is closed, but I did not put a date in the date closed column, I need it flagged. Can someone help write this formula? I am using =IF(AND(ISBLANK([Date Closed]@row), Status@row, "Closed"), "High", "Low") and get the error #INVALID DATA TYPE
-
How to Make a Formula to Count certain "Status"
Hello - I use Smartsheet for my company as a project management tool. I am wanting to set up a few formulas to make seeing open and completed tasks easier at a glance. I would like one to count anything "assigned, or in-progress" and the one to count "completed." Does anyone know how to do this by chance? Thanks!
-
Need help w/formula to provide text output based on specific criterion
Hi team - I have a sheet that I use that has a column called "Type" and based on the type selected (drop-down menu) I need the MII/SLOD/3LOD column (currently a drop-down list) to provide specific text. So if the following "types" are selected, I need the appropriate text to appear in the MII/SLOD/3LOD column (sub-bullets…
-
Is there a formula that can capture the date when a cell changes?
I have a list of dropdown categories to capture the project stage and would like to capture the date when the project stage changes. I also have a list of dropdown categories with the project stage owners that I would like to capture the date of when this changes. My goal is to see how long the project takes on each stage…
-
Is there a way to count the number of parent rows with more than a certain number of children?
I have a column of P/N's in development. Most are individual projects, but some are for customer that have multiple P/N's which are indented under a parent row. I am wanting to know if there is a way to count how many projects I have that contain more than 25 P/N's or "children".
-
Formula needs to ignore parents
Hi All I have a formula that puts a RAG status depending on when the task is due: =IF([% Complete]@row = 1, "Blue", IF(Finish@row > TODAY(+7), "Green", IF(AND(Finish@row >= TODAY(+3), Finish@row < TODAY(+7)), "Yellow", IF(Finish@row < TODAY(+3), "Red", "Nope")))) It works fine but copied down it applies the formula to…
-
IF and Index-Match for status
I am trying to design a cross-sheet formula that will accomplish the following: 1) Source sheet looks at the target sheet/Project # range and and matches a row based on Project # 2) inside that row, source sheet checks the "Routing Progress" column (I've named this range {Grant Approval-RoutingProgress} ) 3a) if "Routing…
-
looking for a blank = how do I enter this into my formula?
I have a countif to look for "tbd", but I also want it to look if someone did not enter "tbd", but left the field blank. I tried to use countifs and add " " after my "tbd", but it does not work. Suggestions? Thanks so much for your assistance.
