-
How to total unique dropdown choices
I have a column that is a drop down allowing only a single choice. Currently, I am counting the totals of each choice by writing multiple COUNTIF formulas. Is there some easier way to get that information?
-
Formula CountIFS Not Returning Expected Results
I'm attempting to utilize the following formula within a cell: =COUNTIFS([1st: Status]@row:[31st: Status]@row, "Completed"). However, it currently displays a value of 0, despite having more occurrences than that.
-
How to check a box if exact text is found within a string of text
Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when "TAC" is found in a string of words. Here's the formula I am using, but its not working. No error message, but is not selecting the checkbox appropriately. =IF(HAS([Column Name1]@row,…
-
Trying to conditionally highlight a cell if "Purchase Date" is greater than Today(-1825)
I've tried using the conditional format logic, but any time I try and set a date condition, other than a calendar date or "TODAY" then I get "not a valid date" error message. I'm trying to set an at-a-glance LCR cell highlight if we exceed 5 years from the purchase date. Sorry to be obtuse, but sure could use a nudge in…
-
Why are my Cross-Sheet References being removed randomly?
I am working on creating a compilation sheet that pulls from 12 other sheets. However, when I finished creating all of the references and started using them in the formulas, something would cause them to self-delete. When I look at the activity log, it says the change was made by Cell Link. Any help in figuring out what is…
-
Formula with multiple IFS?
I'm not exactly sure which is the best way to go about this but my brain is fried so i'll try explain the simplest way. Example: Column 1 - checkboxes Column 2 - list of values (2022, 2023, 2024, 2025). multiple values can be selected Column 3 - Red, Yellow, Green Symbols I want column 3 to have a green circle if column 1…
-
COUNTIFS formula with 3 criteria (2 of the criteria have formulas)
Hi - I am trying to create a COUNTIFS formula using three criteria in the same sheet - Status (I just want to count the Open items), Impacted IT Projects (which is another dropdown of project names to select from), and Severity (this column displays a "High", "Medium", or "Low" value based on the calculated score in column…
-
Two countif statements in one formula?
Hello, I am pretty new to Smartsheet, and I've created a metrics dashboard. If anyone can point me in the right direction, I'd appreciate it. I am trying to use two different criterion to find a value for my dashboard. One of them is a title, such as "Medical Student". I've used =COUNTIF({Reference Sheet}, "Medical…
-
Need help with a SUMIFS function
Hi All I need a bit of help with a SUMIFS formula. What im trying to do is: Source sheet is called "KPI Master data". On a new sheet i am trying to input a formula that will subtract column 4 against column 3 if the date was yesterday in column 1 So far i can get it to work just by looking at a cell =SUMIFS({KPI Master…
-
How to get a countif formula to work when counting a range of a # value
I am trying to count the # of a certain # in a column. But it gives me either an error message (invalid data type) or a "0". I think I have to use countif and value somehow. TIA!
