-
How do I create an CountIF statement to include multiple selections within a cell?
I'm creating sheet summary calculations to tally the total count of a specific dropdown menu item; however, I am using multi-select. I know how to use a standard COUNTIF formula, but it only returns the total count if the option is the only one selected. Here is the formula I'm using: =COUNTIF([Level III Request]:[Level…
-
Can a threshold be set in a Formula or Widget to limit information displayed on a dashboard graph.
Hello, I am trying to set a threshold to limit the amount of information that is displayed on a dashboard widget. I currently have multiple rows of different companies and multiple columns of observation categories (In a graph setup). The populating information is being pulled in using a formula from multiple columns in…
-
Unable to get an avg percentage for some depends for a report
I created a summary report that shows percentages for each task under high-level management. The issue that I am having is when I summarize the percentage column using average. The high-level manager does have a percentage, instead has a NaN. The percentage column is an IF OR statement using quotes to hold the percentage.…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
Formula to lookup prior cell values
...and not require use of the API*. Often, people want to create Smartsheets that use or track values of cells in a(nother) sheet over time, or look up a prior value using a date, or a date formula. The VLOOKUP function could be enhanced to do this, taking a date argument. Or, a separate function created to be used in…
-
Convert Data to a Python dataframe
would like the formula to be added "=py" & highlighted data set
-
COUNTIF with multi select dropdown
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit. In a difference sheet, I'm trying to count the total responses. So Grapes should be…
-
Searching from one sheet's range & search/match to another sheet's range for a unique identifier?
Hello, Is it possible to search from a range in one sheet and search/match it in a different range/another sheet? This has plagued me all day and therefore I can no longer remain clear headed about what the best course of action should be. I have two trackers in completely different departments; QC and PROD. I want to…
-
Formula Question - If not blank, return cell value
Would like to concatenate several cells and have that formula: =[Product Codes]@row + "-" + [Unique ID]@row + "-" + [Deliverable Code]@row Would like to add a cell only if the cell has content along with a dash preceding. Keeps coming back as unparseable. What am I doing wrong?? =[Product Codes]@row + "-" + [Unique ID]@row…
-
I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?
