-
If Index collect formula to capture the Meeting slot availability
Hi All, I'm attempting to compare data from one sheet, which contains meeting bookings, with another sheet that lists all available meeting slots. My formula seems to work correctly when the condition is met ("True"), but it results in an "#INVALID VALUE" error when the condition is not met ("False"). Can someone assist me…
-
Accessing data in column summary at bottom of sheet
I have a sheet with a Time column tracking hours. I want to filter the rows and then SUM the value of this column (which right now does not sum just the filtered rows). I noticed the SUM of the actual filtered rows displays in a summary pop up at the bottom of the sheet when I select the column. How do I access the data in…
-
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…
