-
Sum collect contain formuale
Hi, I am trying to use the SUMIF Contains or INDEX Collect contains but is not coming out right. I am trying to Sum total those projects which Contain Alpha
-
Create a formula to total the individual values of a dropdown list from one column?
So I have a dropdown column that has 12 options and it does allow multiple selections. Each of these items is worth 0.5 value. I am trying to create a formula for another column to report the total value selected in this column by the end user. So if the user selects 3 of these items from the dropdown, I need the formula…
-
Box checked 5 days prior & if Status is not "Completed" or "N/A"
Afternoon I'm trying to have a box checked 5 days prior to an entered date & if the Status column drop down is not "Completed" or "N/A". I have the 5 days prior figured out but not the Status, any help would be greatly appreciated. =IF(AND(ISDATE([Estimated Completion Date]@row), TODAY() >= [Estimated Completion Date]@row-…
-
#NO MATCH due to Smartsheet bug
I received this message after submitting a ticket to Smartsheet. As there seems to be no end in sight I'm curious if anyone else is having the issue and if they have found any solutions to resolve it? ---------------- I'm from the Escalations team here at Smartsheet Support. I was looped in explaining that you are seeing…
-
Identify Duplicate Values On Select Dropdown Selections
I want to identify any new rows that are trying to use the same filename as an existing row. We do have reuses, so I do not want those flagged. I was able to set up a checkbox helper column for Duplicates that identifies any filename that is repeated in that column. =IF(COUNTIF([Filename]:[Filename], [Filename]21) > 1, 1,…
-
Formula help
Hello Just wondering if someone could help me with a formula. I need to write a count if formula Count is Type is Action and Status is not Completed, Decided or Closed. I know how to do on one criteria but how do I add count if not status is not decided or closed. =COUNTIFS(Type:Type, "Action Item", Status:Status,…
-
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…
-
#divide by zero error
I'm trying to create a column formula, but i get divide by zero error in the parent cell. I want the parent cell to be blank, but the formula will populate an answer in the children row. Is that possible? Formula is =AVG([Sep 2022]@row:[Dec 2022]@row)
-
Counting a column with multiple selection and Dates per month
Hello, I am trying to reference another sheet to count the number of times the following "Other, NA, and Blanks has been entered per month "Example for July, August, etc". Any help would be greatly appreciated. "Example Other, NA, and Blanks"