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…
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…
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
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…
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?
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?
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…
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…
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 |…
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…
