Formulas
Discussion List
- Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Comp…
- I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into…
- Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all use…
- I am trying to construct a formula that will make the status turn yellow when TODAY() is 4 days to and 4 days after the date in the [Due Date] column. I was hoping the following would work but it does…
- Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on tha…
- Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized.…
- If cell A is > 30, but < 61, then cell B is "31 - 60"
- I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether th…
- I want to count the number of items when their description contains a certain word. Count if Description contains the word "grey". There would be multiple descriptions with the word GREY in the column…
- Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencin…
