-
Count number of rows
I have a sheet that has a status column which is a dropdown list - In progress, not started and complete. I want to return the number of rows where status is not complete. How do I do this?
-
SUMIF Circular Reference
I have a time/hours sheet to keep track of customers that have varying statuses. The statuses include in progress, complete, and cancelled. I currently have the sheet being sorted based on the status so that It has a title row showing the total numbers for each status below it. As a status changes from in progress to…
-
How to get EOM (end of month)?
How do I get the EOM (end of month) if my start date is 10/07/2016 ? I'm new and having some trouble with this. Thanks.
-
How do you create a "days remaining until start date" column that will select the start date one eac
Hello! I'm new to Smarsheet and haven't been able to figure this one out. I have a sheet with many tasks that have different start and end dates. I want to create a column that will tell me how many days are left until the start date of each task. This formula works: =[Start Date]23 - TODAY() But I need it to automatically…
-
Auto-populate %complete based on dates / duration
Hi, All my project sheets are all set up with project, status, start date, end date, duration, %complete and predecessors. I also have a checkbox column to mark when a task is complete. I'd like to format my % complete column so that it auto-calculates how much of a task has been done based on the start and end dates. I'd…
-
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…
