-
Sequentially Numbering Repeated Values
I have sheet where Group AAA is listed 50+ times then group BBB, CCC, etc.. What formula can be used to sequentially number the Groups like pictured below? Thank you!
-
Is there a better way???
=IF($[Year Select]$2 = "2023", [2023]@row, "" + IF($[Year Select]$2 = "2022", [2022]@row, "")) I am having an issue where I can select 2023 just fine, but when I select 2022 all of my reference dates change to a "Text date" and the formula in the data 1 & 2 columns do not recognize it. Is there an easy way to fix this? Or,…
-
Looking to reference a sheet name on a different sheet
I have a sheet that uses a nested formula to scan 3 different sheets to pull in specific data related to a Sales Order number. Is there any way to craft a formula that will produce the name of the sheet where the information was pulled from? -Using a report will not work because the function of the file is to pull in…
-
Date of column modification
I would like to create a column (Status Modified) that will show the last day that another column (Status) on the same row was modified. What formula can I use to get this information on my Status Modified column?
-
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?
