-
COUNTIFS Reference Another Sheet, Category Type and Date Range
Ask for help: I have a master sheet with all of the data that I am trying to pull from. In this sheet, I have already achieved the desired outcome in the 'Sheet Summary'. Explanation Summary: Count issues by categories types within Q1 Formula in 'Sheet Summary': =COUNTIFS([Category Type]:[Category Type], "HVAC", [Date…
-
Countif todays date and by someone
I want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
-
Checkbox if another field contains text, but don't check if it contains other text
I'm trying to check a box if it contains one of several text strings. But if it contains another subset of text strings, I want the box to NOT be checked. I got it working for the finding text portion, but I can't figure out how to make it remain unchecked if the other text strings are found. Here is the first string that…
-
SUMIFs Contains returning unpareseable
Here is my formula that is not working, any ideas what's wrong? The Audience column has multiple options, but I want to track each individually. =SUMIF(Audience:Audience, CONTAINS("DBM",@cell) [Time Commitment]:[Time Commitment])
-
Combining 2 cell contents and add a space in between (concatonate)
I have combined 2 cells content using + , how do I add space back into the 2 words pulled from the separate cells see below what currently looks like, should be a space between the words! Thanks
-
COUNTIFS function with multiple criteria/specific date range
Hello! I've been having trouble getting this formula correct. Here are the details. I want to count the number of "Agree Strongly" and "Agree Somewhat" in the Survey Results column when the date is the current month in the date column. =COUNTIFS({Survey Results Range 1}, OR(@cell = "Agree Strongly", @cell = "Agree…
-
How can I do a check on data that is "filtered by connector - not synced" to omit data from formula
Hi, I am using a Jira connector and am looking to eliminate any row that's been filtered out by the Jira connector. Is the filtered data in the SmartSheet tagged in any way to use it in a formula? In my dashboard I want specific filtered data omitted from my metrics. Thank you, Dom
-
Nested IF/Or/And Formulas
Hi, I'd like to combine these 2 formulas below but I couldn't. Is anyone please assist me? My story is: if column4 and column5 and column6 are bigger than 30, then make column3 green symbol if one of the column4 or column5 or column6 is between 0 and 30, then make column3 yellow symbol if one of the column4 or column5 or…
-
Calculating weekly/monthly totals by dept
I am using forms for input on a calendar to track how much time is being requested of the workforce by different departments. I know what form fields I need. But I am needing to figure out how to calculate the weekly & monthly time commitment by the Request Originator. I am not sure the best way to set up my sheet to show…
-
Formula for health status of overall project
I was using the below formula to provide the health status of the overall project, but its not working. The result (green, yellow or red) is supposed to come back with the majority of the tasks that are in that color. In doing my test, most of my tasks were in red status, but the result for the overall project came back…