-
Formula to change cell values based on another sheet's column condition plus unique identifier
Hello, I'm looking to change a single cell value in sheet 1, based on the following criteria in sheet 2: All of column A where number = "1234" AND columns B, C, D = "Yes" Essentially, I need the actions from columns B, C, and D to have happened before changing the cell value in sheet 1, but it needs to have happened for…
-
IF/AND/OR formula with different return values
I have created the following formula to calculate the remaining duration of a task: =IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), NETWORKDAYS(TODAY(),[End Date]@row), 0) I would like to be able to add an additional components that allows me to return different values if the Start Date and End Date are in…
-
Set a column to auto add
Hello, Is there a way to set a column to autosum include new rows as they drop onto the sheet from a form? Thank you for any assistance. Rebecca
-
How to append columns of data
Hello, I'm hoping to append multiple columns into 1 (so "stack" them). In this case the first 5 columns would result in the Append column as shown below: Normally I'd use Power Query in Excel but how can we achieve this in SmartSheets. Thanks for any help with this
-
RYG Formula help!!!
I am trying to update RYG using Variance (baseline end - Finish). If Status is complete Gray If Variance = 0 Green If Variance =>-1 and <= -5 Yellow If Variance >-5 Red =If(Status@row = "Complete", "Gray", If(Variance@row =>"0", "Green", If(Variance@row =>"-1", if(Variance@row <="-5", "Yellow", If(Variance@row >"-5",…
-
Auto-number duplicating
I just noticed that my auto-numbers are duplicating on some sheets. My expectation was that auto-numbers provide a unique identifier. Any one how this can happen and if auto-numbers are actually unique?
-
Countif Formula Help!
Hello I have a formula at the moment that is calculating the tenure based on different ranges. The below is example is for those with tenure between 1 and 5 years: =COUNTIF({GOAL C8 Participant Tracker Range 1}, ">1") - COUNTIF({GOAL C8 Participant Tracker Range 1}, ">5") However, I want to add another criteria to this…
-
Cell Linking to Blank Sheets
Is there a workaround to set up cell linking to a blank sheet? I want to set up templates so that, for instance, when a client name is entered in a field, it populates other sheets (similar to an = cell reference in Excel). But, when I try to set this up, I receive a message stating you cannot reference a blank sheet. Any…
-
Sheet to Dashboard Help *LONG post!*
Okay, I have played with this for over a month now so I am going to ask the question from square one and tell you what I've already done to see if anyone can help me figure out how to do this, because I am certain at this point I am making it harder than it needs to be 😂 I will redact some of these screenshots for privacy…
-
Percentage formula based on a checkbox.
Any suggestions on how to make this exceptions formula more accurate? Smartsheets keeps adding 10 rows to my sheet with no data causing my formula to be off. I have 88 rows with data and a total of 98 rows. Out of the 88 row 21 are an exception with the checkbox selected. This is the formula I am using. =COUNTIF({Master…