-
30 Day look back
Hello, I am using the formula below to count all instances of rows that contain "ADCVD" in my "2022 Archive RFI Reason" with my "2022 Archive Created Date Range". My problem is that my Jan 21 data is located in in my "2021 Archive Created Date Range" sheet. How can I modify this formula to look back 30 days in both…
-
Need to Tally and List Unique Values From a Drop-Down
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
-
Count nr. of checkboxes based on another value
I have a sheet with actions. It has a status column (in progress and not started). Further in the sheet I have checkboxes per department. I'm trying to build a report, that shows the number of actions that have status in progress for the specific department. I can do the count of the checkboxes. but need to have the…
-
combining them in the same column
Hi, Can we show the date and time by combining them in the same column? thanks
-
Is there such a thing as COINTAINSIF?
Which function do I use to count the number of times certain letters eg PRJ and TRN appear in a range if in another column the project is open (not closed).
-
What Does This Formula Do?
Does anyone know what the below formula does? =[Project Manager]# This is set as a column formula in the "Project Manager" column and I believe it is filling in the assigned Project Manager contact, but I cannot figure out how it works. It is used to send alerts to the PM, and I need to duplicate the functionality for an…
-
How to calculating the age of a cell in hours
Background - I have a Form, which outputs as a row in a Grid, an extract of which is as follows - The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function). Problem - I am trying to find a formula-driven solution, which…
-
Automated Formula Question
I have two Smartsheets: Config and Labeling. Both Smartsheets have Document #'s in them. The Config Smartsheet has multiple Document #'s in each row, in different columns, while the Labeling Smartsheet has one Document # in each row, all in one column. Both Smartsheets also have a Status column with the same dropdown…
-
If cell is blank put N/A
I have created the below formula to check the contents of a cell and lump it together neatly. However, if the cell is blank, I would like it to return a result of N/A. How do I go about that? Not all cell's will have data and I don't want the summary to be confusing if it's just left blank. ="ABC:" + ABC@row + CHAR(10) +…
-
Count if on two columns
I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another? =COUNTIF({Date 2}, [Start Date]@row) I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX) It is an agenda sheet that has a set…