-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
-
Smartsheet Formula to Click Active Checkbox in Next Row when Complete is Checked in the Row above
Title says it all but I'm putting together a workflow using hierarchy. We have certain tasks that have 6-7 phases in them before they are complete, and other tasks that only have 1 thing to do when they are complete, and I'd like to build an automated formula to check an "active" checkbox if something is a child row and…
-
Index match Help on formula
Hi All I have an index match formula that pulls info from another sheet from a status column made up of a drop-down with fifteen values. This is restricted to values. When I find the corresponding match, the formula works great, but if a value is not found, It returns a default value, which is not specified. I would expect…
-
I NEED HELP GET THE smartsheet equivalent to excel formulas
Formula A =IF((OR(B8="K",B8="PO", B8="", B8="via")),SUMIFS(Contract!R:R,Contract!E:E,C8,Contract!F:F,"0"),"NA") Formula B =IF((OR(B10="K",B10="PO", B10="", B10="via")),SUMIFS(Contract!R:R,Contract!E:E,C10,Contract!F:F,">0"),"NA") Formula C =IF((OR(B9="K",B9="PO", B9="",…
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
How To Collect Data based on date and post to proper month column
Hi All! I have a several large projects running in a portfolio. The projects are all construction in nature and with each project there are subsections of construction each with target completion footage and target completion dates. I would like to build a report to show me the total build footage across the various…
-
Formula to count distinct values in a column that contain a certain text string
I am looking for a way to count distinct values in a column, but only if the values contain a certain text string. For example, in my Fruit column, I'd like to count the unique values that contain "Large." In this case, the number should be 3. Fruit Apple - Small Apple - Medium Apple - Large Orange - Small Orange - Medium…
-
Need Help with #INVALID DATA TYPE Error for COUNTIFS Formula with Multiple Cross-sheet References
Hello, I have this formula: =COUNTIFS({Certifications Range 2}, CONTAINS("CyberArk", @cell), AND({Certifications Range 1}, CONTAINS("Expiring", @cell), CONTAINS("Current", @cell))) I keep getting #INVALID DATA TYPE Range 2 and Range 1 are both referencing Dropdown list columns from another sheet. I know that the problem is…
-
Help with formula
I am working to port a process that is managed in Excel into Smartsheet. I want to created a formula that will check two cells in the row, if they both show filled, I want to check the checkbox. If either or both are any other status, I want the checkbox to remain unchecked. I want to convert this to a column formula. When…
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
