-
Circular Reference
Smartsheet Community How do I SUM this formula with in the Same Row without Receiving a Blocked or Circular Reference? Row17: IFERROR(Passed17 / $[Total Test Cases]$17, 0) Row 18:Is a Sum within the same Column as Row 17 =SUM(Passed18:Deferred18) Thanks
-
Flagging/Removing duplicate rows that do not include comments
We have a newsletter that gets sent out, and tracks if anyone opens or clicks through them. That Excel file is uploaded to Smartsheet. We then follow up with anyone who interacted with the newsletter, and follow ups are tracked with comments. Is there a way to delete duplicate rows based on whether or not there are alreadyโฆ
-
How to Limit Access to Smartsheet
I know this question likely goes against all that is Smartsheet, but... We have a sheet setup to take submissions from a form. When a new row is added, a contact in a column is notified. After the row's status is still "in progress" for 3, 6, and 9 days, the contacts get reminders that these rows are still "unresolved" andโฆ
-
SumProduct and Countif
I need help trying to count the total matches in two ranges with a criteria. I don't have this problem with Excel using the following formula method. =SUMPRODUCT(COUNTIFS(C1:C5000,J1:J9,D1:D5000,"Customer 1")) What i'm doing is using a total of 3 different sheets, 2 are .csv files being uploaded with datauploader using theโฆ
-
RYGB Symbols Average Formula
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far. =IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red",โฆ
-
Survey Form(S)
I'm currently working on Survey Form. I have made one for one "X" department. I need to make another survey for for "Y" department. The two departments have different heading but the two have same questionnaire but different employee names. How do I clone the first form into the second. And is it possible to the resultsโฆ
-
Automatically assigning no symbol if finish date is blank
HI, I am assigning Blue(Complete), Green(On Track), Yellow(Due in next 5 days), & Red (Over due) symbols to each task in a product plan in order to create a task status report. Becase I have the red symbol set as finish date in the past, all tasks with no finish date are showing up red. Can yuo help me with my formulaโฆ
-
How can I count dates in the past/future?
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date inโฆ
-
Multiple Criteria, total count
Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -NDA Webinars. I don't want it to count each column that matches the criteria, but if theโฆ
-
=IFERROR formula
Hi Within my project plan sheets I have 2 columns , On Time/Late and RAG. On Time / Late Column Formula =IFERROR(IF(AND([Original vs Current (days diff)]@row > 8, Status@row = "Complete", Milestones@row = "true"), "Late", IF(AND([Original vs Current (days diff)]@row <= 7, Status@row = "Complete", Milestones@row = "true"),โฆ