-
Yesterday's Completed Task Formula
I am looking for a way to capture the number of taks that were completed yesterday. I started by using a report however yesterday or last working day were not an option. I tried using in the last days - and used 1 however when yesterday is a weekend is skews the data. I then tried using a COUNTIFS formula but I run into…
-
Formula help: IF AND (drop down list in column and date column)
I need help with a formula. I have 2 columns I need to test true for. I would like that column to indicate Red, Yellow, or Green in the "Health Column". I need the "SCAA Stage 1 Completed Date" column and the "Content" columns to work together. One is a list and one is a date. I would like logically if SCAA column is a…
-
Auto-update task status or priority when predecessor is completed?
I am looking for some way of having Smartsheet automatically change a column on a task once a task that it is dependent on has been completed. This is so that I can see what new tasks need to be worked on. For example, task B is dependent on task A. Once I have flagged task A as complete, then task B automatically gets…
-
Sum cells in a column based on check box status?
I am currently using a SUMIF formula (which works as expected) to sum values in a column when a row contains specific text =SUMIF($[Activity]$29:$[Activity]$344, "Consultations", [FY 2016 YTD]29:[FY 2016 YTD]344) Now I want to add a check box column so I can an another clause to my SUMIF statement to sum only those rows I…
-
SumIf across SmartSheets
Is there a way to create a sumif formula that references cells on a different sheet. If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values match worksheet2 comlumn5 values. Example: =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2) I can't figure out,…
-
Conditional Date Calculation
hi, I have months columns Aug-2016. .Sep-2016 etc., (just the names of the Column are months, but the Column property is Text/Number) and each month has a number value. I'd like to be able sum those numbers based on a condition - The current month's number + 4 more months from the current month should be summed. Eg: When…
-
IF Statement
I am currently working on an IF statement for RYG. I currently have a statement that turns green if the task is not on the due date and in the future. I have it turn yellow on the due date and red when past due. I am trying to get the IF to work adding grey to the mix that if the column done (checklist) is marked that it…
-
Only evaluate today() once or freeze date cell once populated?
I would like to automatically record the date a project is marked complete. I have a dropdown column with "complete" as an option. I have a "date closed" column that return today's date if the dropdown column value is "closed". Of course, the next day, "today()" wil evaluate to the current day and not the day it was…
-
Formula help - if cell is blank, checkmark cannot be checked
Brain cells are missing. I've looked through the formula examples and can't seem to put together the formula I need. We have a column that needs to have text in it before the Checkmark column should be marked with a check. Here's the scenario: IF column B is empty, checkbox cannot be checked. This will help our team…
-
Hide $0.00
HI when i use =SUM(CHILDREN()) it shows $0.00 value....I would like to hide this value until its greater than 0....probably easy....thanks
