-
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!
-
Formula to populate date from another cell if blank
Hi, I'm struggling with what feels like it should be a simple formula, so hoping the fabulous community can assist. I need to copy the date from the Creation Date column to the Start Date column when it is blank and leave the existing date if it not blank. All the formula's I've tried either give me a circular error or…
-
Count entries made the previous week
Hi, I am looking to create a sheet summary formula that will count all entries on a sheet that came from the previous week. I figure that it will have to be a countif formula and will incorporate weeknumber but I am lost on how to count from the previous week and have it keep updating for the next week.
-
Trying to copy and paste formulas to a new sheet
I understand that adding a single quote, ' In front of a formula row allows you so see, copy and paste that into a new sheet. I am trying to add a single quote in front of 102 rows with formulas but the join function is only allowing me to join the two cells. My thought was to add a text column with only the single quote…
-
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
-
Calculate date based on review type and date of last review.
I have a sheet to track 90 day and annual performance reviews. I would like to create a formula for the 'Date of Next Review' column. I am trying to calculate if 'Review Type' is 'Annual Review', add 365 days to 'Date of Last Review'. If 'Review Type' is '90 day review', add 90 days to 'Date of Last Review'.
-
Count the number or non-blank cells in the specific ranges for 2 groups of rows
Hi, I'm trying to count 2 ranges of rows (in the RP Opportunities column) where cells are non-blank and also matches with the value of another column (this is a drop down list column with values "RP" and "Canada") In this case I need to count only the non-blank cells if the value in the column named "queue (RE and Canada)"…