-
Link to most recently added row
I'm looking for a way to display (in Sights, but if you're not a user of Sights, just think of it as linking from one sheet to another) whatever the last row was that was added to a sheet. The way I'm conceiving of this is when a row is added, the top row in the sheet contains formulas that grab that information. If I were…
-
How to import data from another sheet
I am very fluent with Excel but find that it doesnt work completely the same with Smartsheet. I am trying to import data from another Sheet i.e. Sheet1 A1= 200 Sheet2 A1='Sheet1'!A1 How do I do the same thing with Smartsheet and then hide the formula?
-
Need Formula for Automating RYGG Balls
I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are. If end date is prior to TODAY, = Red If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green If…
-
Conditional Formatting Based on 2 Different Cells
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
-
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
-
Formula with multiple conditions and logic
Help! I'm trying to create a formula that automates RYG balls based on many different factors across multiple cells. I'm having trouble because the "IF" formula that I created is stopping at the first point of validation that it finds to be true and instead, I need it to keep moving on the validate all points. Here's what…
-
Problems with LOOKUP formula
Hello, I'm encountering an issue with the LOOKUP formula in Smartsheet. Apparently it doesn't work with the names that I use in my lookup range (note that I dragged the formula down to the bottom, using "$" to block the rows of the range, but I get no results): I would like to understand why it is not working and if there…
-
CountIfs and Blanks, not blanks
Hi Guys I have two columns of data that I want to summarise with a count into a specific cell where the follpowing conditions are true: The first column is NOT blank AND the second column IS Blank. Not sure if CountIf's is right for this. Any help would be appreciated! All the best Barry
-
Total count based on values from two columns
Hello, I'd like to check the text in one column and a check mark in the second column and then get a total count based on that. The first column is Scope which can be A or B. The second column is complete which is a checkbox that's either checked or unchecked. What I'd like the formula to do is check the Scope column. If…
-
How to calculate effort relative to working hours?
As a new user I'm working my way through the Smartsheet product. Thanks to the 'best answer' in this post I was able to calculate the Effort (or Energy), which is visualized by 1 to 5 people-icons; this way Duration can be set or calculated for regular project planning, but in Card View this is automatically shown by an…
