-
Formula for projects due to start in X no. of days
Hi again, Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error. Please don't get confused with the formula. The projects I created have 5 subtasks and as an alternative solution,…
-
Count Task Status across Sheets
For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total number of tasks which are Red or Yellow. I can easily create the report which shows the list of individual tasks which are…
-
Struggling with If statement
I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. Here is what I have, that is not working: =IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1))) Estimated Close Date is a date column. The formula I am trying to…
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Allowed Values depending on Value in another column
Dear Smart Sheet Users, as a newbie, I'm not familiar handling depending possible values in Smartsheet. We want to approve a deployment process. If a user chooses value 1 in column A during data entry then there should only be a sublist of possible users to send the approval request in column B - if a user chooses value 2…
-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Formula help
I have a date column for bid due dates. I'm trying to create a formula that gives me a count of how many rows have a due date coming up in the next 30 days. So far nothing we've tried has worked, not sure why. Does anyone here have a suggestion?
-
Automate Formula Criterion
I'm sorry if the answer to my question is available. I could not find information about automating a scheduled update criterion included in a formula. For a monthly dashboard, I created a series of formulas to count the number of topics at various development stages, total days in each stage, and the cycle time between…
-
Parent-Child Formula for Percent Comnplete
Good Day All: How can I change the following formula below into a parent child relationship so if I add additional rows, the parent will automatically include the child in the calculations for overall percent complete. Does anyone have the Smartsheet % Complete Formula that is hard coded within the Project Settings? Thanks…
-
Automatic Target %Completion by Date
Hello, I'm trying to configure a column to reflect the Target % Completion based on days from Finish date but am hitting a snag for Finish Dates that have passed (resulting in a percentage higher than 100) or Start Dates that haven't arrived yet (resulting in a negative percentage). (I do understand that you can't add a…
