-
Does anyone know why the COUNTIFS function used with a DATE range stops counting things done at 7PM?
I am currently using this function: =COUNTIFS({Closed}, <=DATE(2020, 4, 30), {Closed}, >=DATE(2020, 4, 1)) to calculate the number of projects closed every month. When I compare the number that is calculated to the number of rows in the sheet that it is referenced, it doesn't match because everything that was closed after…
-
How do I resubscribe a user?
I have a smartsheet set up for forms on our website and I created a workflow that sends to a specific email address whenever a new line is added. They contacted me to say they were not receiving the notification emails so when I checked the workflow -- I noticed the attached message. Someone must have unsubscribed from the…
-
COUNTIFS based on conditions
Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH. I have all of the data in 1 SS and am totally and running metrics in another. In the sheet I'm running the metrics in I have a row for each cohort, and where I want the count to…
-
Need help with Formula
Hello I am not an expert in automation, So need your assistance in mapping one data. I have requirement wherein in one Smartsheet I have values in 3 columns and on the other Smartsheet I have all the values present 3 columns in Sheet 1 is present in a single column. I need put a function in such way that the formula first…
-
RYGB and Check Box
Hello everyone, I am a new Smartsheet user and having problems with a function. When the "Blue" ball is selected in the Health column, I would to automatically have the check box in the Complete column checked. Embarrassed to ask such a simple question. =IF(AND(Health@row="Blue",) (Complete@row=1,1)) Greatly appreciate the…
-
What is wrong with my COUNTIF formula?
I am not sure what is wrong with my very simple formula... =COUNTIF(Quarter:Quarter, "Q1") I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in sheet summary and keep getting #imparseable or #invalid data type (if I add "quotes" outside Q1) I am creating a new field…
-
How Do I Count the Number of Occurrences of Text Across Columns?
I am trying to count the number of instances that certain text occurs across columns in a sheet. How do I count the number of "F"s, and "P"s across these columns.
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
-
How do I do a row request?
I am trying to create groups of tasks that can be used by using a filter. Unfortunately I need to be able to know the row# of all added rows in order to have the new rows visible for each group. I want to have a cell that marks the start of a section and one that marks the end. The ones between need to be filled with the…
-
Formula most urgent topics with RYG, date
Hallo, I want to combine the following columns with a formula in the sheet summary: RYG, date of receipt, comment and hotel The sheet summary should show "hotel name" and "comment" if RYG = "red" and (the earliest date of receipt as most important aso.) Hope you can help again ;-)