-
IF(AND) Syntax Question
I am trying to correct the SYNTAX for the below scenario as I repeatedly get #INCORRECT ARGUEMENT SET as a result on line 3. In the column labeled "Today" I have the following formulas: LINE 1 =IF(MONTH(TODAY()) = [DOJ Anniversary (M)]1, "YES", "NO") ..... This returns the expected result. LINE 2 =IF(MONTH(TODAY()) = [DOJ…
-
Spreadsheet with multiple tabs
I was maintaining an excel spreadsheet with multiple tabs, and some of the fields under these tabs were similar, when i would update this field in master tab, then it would populate the same informatoin on similar fields on rest of the tabs. I imported this excel spreadsheet in to smartsheet and it is importing only first…
-
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…