-
Sum the number of Grandchildren check boxes
Hi all! I'm trying to figure out the formula for how to sum the number of check boxes from the parents. I have the children figured out but it is the summing of the parents that isn't working. (See Picture) I would expect the Retail line to say 3 instead of zero. The formula that I thought would work is ="" +…
-
Automatically set a date based on a checkbox
I want to be able to automatically set a due date of the next day based on a 2 criteria 1) a check box is checked, and 2) a cell having text in it. For example (we do cabinet installations)...A check box for "repair doors needed" is checked, AND "Repair door sizes to order" cell has text in it. When those 2 criteria are…
-
Sumif using a variable
Hi, I have a simple sumif adding values from column Estimate based on some text being present in column Artist. The result is all the time allocated to a particular artist. =SUMIF(Artist:Artist, "Alex", Estimate:Estimate) In order to make this more compact I would like to have a pull down menu with all the artists names.…
-
COUNTIFS a start date is less than today, and is an ancestor level 3
I am currently struggling with the following COUNTIFS formula =COUNTIFS(AND([Start Date]:[Start Date], <= TODAY(), ISDATE([Start Date]:[Start Date]), [% Complete]:[% Complete] <= 0.5, [Helper Column]:[Helper Column] = 3)) It should read as follows... Count a row if it... has a Start Date that is less than or equal to today…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Getting status of a RYG with a Date Column
Greetings, Thank you for taking the time to read this. I am a newbie to both programming functions and to Smartsheet. I am working on a sheet where I require to report out the RYG Balls on the end of calendar months. I have two columns I need to create a function for- "Date of Update" and "Status Report." When the Status…
-
Translating Date Formats
We have Smartsheet integrated with another system and pulling data across into Smartsheet. Currently the date format that is coming across is (YYYY-MM-DD) and I want to translate that into my local profile date format of (MM/DD/YY). Is there a function or formula that allows me to do this? I have been unsuccessful in my…
-
If Statement for three columns
Hi Guys! I am working on the following Formula: =IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK") Goal: If the date in a date column [Date Completed] is more than 3 days ago, and the cells for the next two columns are empty - one or both - I want to remind our technicians to fill…
-
if statement
Hi, Can someone help me on this formula. Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No.
-
If Status is "Completed" then make % Complete "100%"
I need help with the formula to automatically make the % Complete be 100% for any row where Status is "Completed" Do I put the formula in the % Complete cell? And if so, what formula? What I have tried so far does not work: =IF(Status=Completed,%Complete=100%) That's probably wrong for a variety of reasons, but I can't…
