-
% complete manipulation
Is it possible to have a second % complete column that somewho only shows what % of work for child tasks that have a start date that is <= Today. So basically I want to know what % of work is complete that should have already started. I would only use this formula on the top level parent row of the whole project and it…
-
Formula for pulling Start and Finish from cell
Is there a way to pull Start and Finish data from a cell that has both? I'm importing a spreadsheet schedule with cells that have both dates expressing a date range, eg. "2/1 - 2/7"
-
Adding up checkbox's
HI, everyone. Please assist here: How do I add the number of checked box's in a series of cells in a column. The answer is on the formula example sheet but I am not getting it. I have 7 questions that require a check to indicate yes or a non checked box to indicate no. I want to add the number of checked box's to get a…
-
Automatically clear a flag symbol when a completed checkbox is selected.
Hi, I have created a simple workflow for testing a product. Within the row is a flag symbol column which the user selects to denote a fault. And when the fault is fixed a check box is selected at the end of the row to say it’s been completed. The fault flags throughout the sheet are counted in a running total as is the…
-
TIME and DATE/TIME (long)
Hi, This is not a new thread, but rather a branch of the thread derailed (mostly be me) of this thread https://community.smartsheet.com/discussion/question-formula-results-reports starting here: https://community.smartsheet.com/discussion/question-formula-results-reports?page=1#comment-17893 The derailed topic is…
-
SUMIF with check mark
I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? =SUMIF([Have we paid for this container?]1:[Have we…
-
BUG: Auto-fill behavior has changed
This used to work, I've used it in my workflow, documented it and passed it on to the customer. Now it doesn't. I have a sheet, 22 columns wide. At the top of the sheet are several rows (in this specific case 4) The first column has a formula in it in rows 3 and 4. Previous workflow: 1. User deletes all content from rows…
-
COUNTIF formula with a date
Hello, I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found).. I have a column that has a date field, and some rows have dates entered, some do not. I need to reference on a sperate sheet…
-
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…
-
Automating RYG balls based on checkboxes
I'm trying to create a function to accomplsh the following: If coulumn 2 is checked, and column 3 is not checked, then the RYG ball in column 4 is green. If Column 2 is not checked, and column 3 is checked, then the RYG ball in column 4 is Red. When nothing in column 2 or 3 is checked, no RYG ball is displayed in column 4.…
