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!
=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,…
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…
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?
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?
