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 > T…
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 do…
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 c…
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…
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 …
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 afte…
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 eith…
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 ente…
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 …
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variab…
