-
Trying to pull data within a date range - need assistance with the formula
I'm attempting to collect data across sheets and am having a hard time getting my formula right. I want to collect the number of sites in a program that falls into a particular date range. So, I want to pull from our intake sheet all sites in Program A that are due between 1/9/23 and 1/13/23. I've tried a couple of…
-
Column Properties using Symbols
Anyone here used the 6-state Pain Scale in their sheets/dashboards? We plan on using this for our customer satisfaction survey and I want to know how you guys came up with the formula. If there's an article available around this might be helpful too. Best, Grace
-
Average If formula to calculate if multiple criteria is met
Trying to create a formula that will average the # of days based on the contract manager name & if the dates are for the month of June. This is the formula I'm using which works until I add the date range in. The data is in 2 different sheets. =AVERAGEIF({CM SLA (received to opened) Range 1}, [Contract Manager]@row, {CM…
-
Adding two columns together for a total sum
Hello, I want to add a formula to third column (highlighted) that will add "# Dock Doors" and "# Trailer Parking Slips Onsite" together and it to total in the "Total Trailer Locations Onsite"
-
Split contacts to multiple columns.
In my sheet, I have multiple contacts in one cell. I would like to AUTOMATICALLY spread these contacts across multiple columns in the same row, so that each column has one single contact. The reason I want this is to send approval requests to each contact. (Currently, I can only send approval requests to all the approvers…
-
How can i make a row automatically get created and updated in one sheet as it is created elsewere
Hello world! I am trying to create a overview sheet that will be fetching values from two different lists. The two data sheets have a identifier number for each row in them, but placed in differant coloumns were only in one of the sheets is this identifier the Primary coloumn, so automating copy and paste row to other…
-
TRYING TO COUNT MULTIPLE DATA IN A COLUMN
looking to count all the data from 4P100,4P200,4P500 etc in one row the deal I have is 0-500 501-1000 1001-1500 I am not wiz at this but I am trying to learn
-
Which formula do I need if I want to count issues assigned to 2 people that are counted for each ind
Hi everyone, I am fairly new to Smartsheet and this is my first question in this community! I have an Issue Tracker where issues can be assigned to multiple people. On one of the charts on my dashboard I am showing how many Issues are assigned to each individual. I have a formula that counts if an issue is assigned to 1…
-
Counting items from a text/number field
I have some users where we set up a text field and they are pasting information from Excel into the field. The info is nicely formatted and appears to have carriage returns when I wrap the text, see below. I am wondering if there is a formula that would help me count the number of items in the cell. Thank you
-
I keep getting "unparseable" ... what am I doing wrong?
I have 3 columns (A, B, C) with yes/no responses. I want column D to return a response of "contractor" if the response to Column A = yes , Column B = yes, and Column C = no. I have been trying: =IF(AND([A]1 = "yes", [B]1 = "yes", [C]1 = "no"), "contractor") What am I doing wrong? THANK YOU!
