-
Conditional Formatting Help
See Screenshot Example Please Goal: to compare cells in 2 rows across columns. All numbers in both these rows are based off formulas. I want the cell in row "needed machine hrs" (column 1) to turn RED, IF the number is greater than the number in the cell directly below it, in row "Current Machine/Labor Hrs" (column 1). Is…
-
Automating RYG balls
Presently I have a RYG IF formula to do the following. =IF([Commitment Expiration Date]11 < TODAY(), "Red", IF([Commitment Expiration Date]11 = TODAY(), "Yellow", IF([Commitment Expiration Date]11 > TODAY(), "Green"))) I would like to change the automated RYG balls in my sheet to turn “Green” if the Due Date is in the…
-
Countif formula if a row doesn't have any children
Is there a way to write a COUNTIF formula to count the rows that do not have any children? I would like to write a COUNTIFS formula that counts: 1. % Complete is < 1 2. Finish is in the past 3. Row doesn't have any children I know how to write the first two. I'm struggling to write the 3rd one about children. Below is a…
-
If/Or Statement
Hello all, I am relatively new to Smartsheet and have hit a wall in trying to automate a RYG. I am looking to change the color by listing multiple possibilities from a range of cells. My idea was to create a separate column for the formula, hoping to return a "1" or a "0". Then I could add a simple formula in the RYG…
-
Forms, Formula and fixes - Oh My!
Hello, I have created a web based form in which the user fills in certain information. As part of our metrics we need to keep track of when an quote is finished and completed. I have a date column for the quote finish and a checkbox cell for complete status. Our reports use the checkbox cell as the primary filter.…
-
Help on Formula for: Savings over time calculation
Hi again, I am new on formulas and been conducting some tests on my project tracker. I wanted to get the monthly savings on projects with completed status. I always get a zero even if there's a value on my savings column. Please let me know which part of the formula is incorrect and what is the best formula should I use if…
-
Formula / Multiple Sheet Reference Assistance
Hello! I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project. I have one column that uses a VLOOKUP to…
-
Billing Date Formula
Looking for a formula that generates a renewal date. Here are my three column headers Column 7= Return Date Column 8 = Paid Through Column 9 = Next Invoice Date I want the Next Invoice Date to be either the Return Date or the day after the Paid Through Date. If the Return Date is Blank, the Next Invoice Date is the Paid…
-
Formula for Automatic Date Entry
I have 2 columns to be used in this formula: One is for the Date Completed in Date Format, and the other is the task Completed checkbox column. I would like to create a formula that automatically enters the date as Today's Date in the Date Completed column if it is empty, and the Checkbox is checked. I've tried to do this,…
-
Countif and countifs not updating
I have created a smartsheet with a number of different formulas in to pull together monthly figures. I then use this information to populate charts in my sights. One view I use is to count the number of new jobs added each month. This was working great until latest update. When I look at my sight the chart is no longer…
