-
Number of Items Opened and Closed in a week.
I have a worksheet named "Rich Complaint" that holds the data. Another worksheet named "Calc Data" that holds the calculations for the Dashboard. I want to write a formula in "Calc Data" that looks at the columns in "Rich Complaint" named "Date Created" and column name "Date Closed" to determine how many items have been…
-
Count if *specific word* is present, alone or among other words.
Hi all. Looking for help with a formula where the excel method does not work in Smartsheet. I want to count the number of occurrences of a word where sometimes that word has other words in the cell. I need SmartSheet to count the word whether or not the word is in a cell by itself or among other words. I am adding this…
-
If date range includes a Friday - check a box
I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in advance. Jennifer
-
Count If combination of two values occurs multiple times
Hello community, I'm trying to count if or flag when a value repeats in two columns. As you can see below I have the formula for one column but I want to count if both Location and Count Cells Duplicate. In this instance I can see that a combination of 'London (location) 3 (count)' occurs twice... What is the formula for…
-
How to display the Assignee(Contact) of Successors?
I would like to display the Assignee(Contact field) of Successors. I currently use a Successor formula to successfully reveal which task rows are dependant. How can I also reveal who the next assignee of that task should be?
-
Getting Invalid Data Type when trying to use Date() formula
Trying to convert a drop down date to Date format, so I can program some automations off the date. Keep getting Invalid Data Type. My date column below is Date format the rest are all text. Can anyone see what I am missing?
-
Help with Join/Collect and Has and Not/Has formula
Hello, I'm stumped on this formula and need assistance please! I am trying to populate Courses to Approve -Dean column based on the choice in the PC or Chair Approval Column. It works until I get to the "Some Courses Denied" choice in the PC or Chair Approval Column - which then is supposed to be taking the courses listed…
-
Network Day giving negative number for the same day
We have this formula to give us how many days are left for the Purchase order =-NETWORKDAY([Due Date: PO Ready]1150, TODAY()) But whenever I have today selected I get a negative -1 as Day Remaining Same happens when I select day after tommorow just gives me 2 as Days remaining How can I fix this? When the days are more or…
-
Find unique value in Children
I am looking to determine if a value in a cell of a child is unique among the other children. Order Number | Items | Cost | Overall Unique | Order Unique | Total + 100 | | | 101 | Oranges | $1.00 | Yes | Yes | $1.00 102 | Apples | $2.00 | Yes | Yes | $2.00 103 | Bananas | $3.00 | Yes | Yes | $3.00 + 200 | | 204 | Pears |…
-
Issue with nested IF formula looking at the 1st column THEN 2nd column (to feed INDEX/MATCH data)
I am having an issue with this formula and need help :) I am wanting the formula to look at the "Lead CTC Region" column for Canada first (and pull in the "Lead AE" data with the INDEX/MATCH piece) THEN I want the formula to look at the "Lead CTC Global Region" column (and pull in the "Lead AE" data with the INDEX/MATCH…