-
I need help with a count formula
Hi All, I need help with a Count formula. I columns that have a 3 option dropdown and I want to report on the number for each using a formula (Countif /s or any other formula). I am happy to setup 3 separate formulas for each of the 3 options, so don't need anything fancy. Just need help creating a formula that counts the…
-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Formula in cell A1 to update the count of a column
This discussion was created from comments split from: Formula to count values in a column.
-
IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being…
-
combining 2 logos
Hello Smartsheet Community, Has anyone tried combining or using 2 logos on one sheet or form? Or know how to do it? Thank you in advance, Charlene
-
Using CountIf with multiple columns and dates
I am attempting to Count certain instances across 2 columns. Example, I want to count all Near Misses that occurred in February of 2021. I have figured out how to count everything that occurs in February. =COUNTIFS([Date Reported to Manager]:[Date Reported to Manager], IFERROR(MONTH(@cell), 0) = 2, [Date Reported to…
-
SUMIFs for last 7 days
I would like to sum the last 7 days of a column on a daily basis. No matter what day it is, I want to know what the sum of the last 7 days is. I'm using this formula in a summary: =SUMIFS([Workshop Signups]:[Workshop Signups], Day:Day, TODAY(-7)). When I verified (tested) the numbers, it totals the last 6 days, including…
-
CountIF Function for Licensures Expiring w/in 90 Days
Hi! I would like to get help on writing a coutif function that will count all licensures expiring within 90 days. My current formula is below. It is not giving me the right number on my dashboard when I double check it against my report (which shows me all licensures expiring in the next 90 days). =COUNTIFS({BLS Expiration…
-
Adding multiple columns if one column equals X
I have a multi column sheet. If column Alone= CN, I want to total four columns. =SUMIF([$ Regular]:[$ Regular], [$$ xyz 2021]:[$$ xyz 2021], [Per Item $ 2021]:[Per Item $ 2021], [null 2021]:[null 2021], [Revised $$]:[Revised $$ ], (Alone:Alone, CONTAINS("CN", @cell)) I've tried ever iteration and I cannot figure it out.…
-
Remove health from Project Level row
Hi! I'm trying to remove the health function from the upper hierarchy/project level row in my project plan. The way I have it set up will give a health of Red if the due date is past and I only want health at the phase and task levels. Do you have any suggestions for how to edit the formula? =IF(ISBLANK(Status@row), "",…