-
Stumped on what formula to use
Hello! I struggle with formulas no matter how many times someone tries to show me how easy they can be. I hope someone here can help me figure out this solution, because I'm not sure what I'm doing wrong (or even if what I'm looking to do is possible). I have an intake form I'm using to collect feedback from requesters…
-
Partial Index Match on an identity field
I have set up a dynamic dashboard where users can filter by their name to determine how many documents they are required to complete. On selection of the count a report is opened with the list of documents assigned to them. I am running into an issue on the report when a single document is assigned to multiple people as…
-
Formula Question
I am trying to find metrics on everything that is not multiple things. This is a drop down column that has a list of options and I need to exclude from the count CEG 1, CEG2,...., CEG7 I attempted to use this formula =COUNTIF({ColumnReferencetoSearch}, "<>*CEG*"), but the total it gives me is incorrect (2653). I know this…
-
If Then Formula for 2 Columns
Hello everyone, I'm still a "new" Smartsheet user even though I've been using it for over a year. I want to set up the following formula: if column A equals 1 then column B equals 2. I want to apply the formula to both columns. For more specific details, the terms I'm using are: IF VPM Categorization equals Cost, THEN…
-
Formula to tally revenue from columns in reference
I'm setting up a Metrics Sheet and want to tally up the revenue received for all sessions delivered for each month. For example, I want to know how much in revenue we received for webinars in January, onsites in July, etc. The columns in the sheet are Month, Onsite or Web?, and Revenue for Session. All three columns on are…
-
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…