-
Assistance Needed (#INVALID DATE TYPE)
I have a sheet with multiple rows and columns. Two of the columns are for Recruitment Stage and Recruitment Priority. Recruitment Stage has (7) dropdown values, and Recruitment Priority has (6) dropdown values. I'm attempting to use a COUNTIFS statement to produce a total count of partners who are either in the…
-
Count(Children()) Not Counting Correctly
I am trying to create a rollup of the status of the phase using a modified version of the method from this post: The problem I am running into is somehow the simple COUNT(CHILDREN()) portion of my formula is not counting the correct number of children. As shown in this screenshot, there are clearly 3 children of this…
-
Sum Formula when a Formula is used to Generate a number
I am trying to sum Cells that contain a number that is generated from another formula. However, the sum is not generating. These are the steps I have followed. Does anyone know how I can fix this? I have a series of cells that are populated through a form as Yes or No questions. If a question is answered yes it is assigned…
-
What is the formula to flag duplicates from a multi-select drop down column?
Here is the formula that I have been working with. Currently I have it build out to where it flags duplicates but only if it is a "single-select". As soon as I select multiple times in the cell, it won't flag the duplicate anymore. My goal is to have any duplicate flag so that people aren't scheduling over a time that has…
-
How to make an =SUM formula return zero when cells in the formula are blank?
I'm making a simple smartsheet and have a column adding several cells. Then have a status ball change colors based on certain numerical conditions. I need the SUM formula to remain blank and not 0 because blank is blue (not started) and 0 is green meeting goal. Thanks in advance for any assistance.
-
Adding Months to a Date
Hello! I've been hunting and cannot find a solution to a problem that shouldn't be complicated. I need to add a varying number of months to a date, and spit out a new date. Specifically: Date Opened + MTE = Expected Completion Date. For the life of me I cannot get it to work. Any ideas?
-
SUMIF w/ Negative numbers
Hello, I got a quick question for you amazing people. Long story short, I'm trying to create an attendance tracker that tracks things like tardiness, call outs, pto, fmla, and overtime. I feel like I got something substantial, but I'm missing a small component. So the idea is that we track all these different occurrences…
-
How to connect symbols with text
Hi, I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change the status of the project. Please see the attached screenshot.
-
Replicating Formula
I am having an issue where I have a formula working on one sheet but when I copy the formula to perform the exact same function on a different sheet, it does not work. I'm hoping someone could look at both sheets and let me know what I'm doing wrong.
-
Getting top-level heading's rank
I'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first top-level heading, make it green. If it's under the second top-level heading, make…