-
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
-
Formulas - Results show an extra 2
I have a very basic SUM formual in my smartsheet. The resulting number is 2 more than it should be. I've cleared the forumla and built it from scratch, and double checked the data in the column. If I handcount, I get the right answer, but the SUM consistently is 2 over. Simiarly, in the next column, I have a COUNTIF…
-
Formula to check percentage total
Hi I have a sheet which is pulling through some data from other sheets via cell links. The cells are being pulled from a Project Plan (with rolled up section totals). Based on this data, I want to set some conditional formatting on my sheet. I have: %COMP STARTDD ENDDD 55% 10/08/16 22/08/16 I'm using a formula (hidden…
-
Subtotal Formula
Hi, I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field. I tried to apply the same forumula but not working on smartsheet. Is there a way to calculate subtoal of the filtered rows? Please guide.
