-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
-
Status Auto Fill if due date passes
I am trying to figure out how to have a "status" change to past due if the due date occurs and the status is not "complete." Is there a way to do this? Thank you!
-
Index Match returning blanks when there is a Match?
Hello, I have a nested IFERROR Index/Match that is returning a Market Code based on a Unique ID. Formula looks more complicated than it is: =IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(INDEX({CA}, MATCH([MPL #]@row, {CA}, 0), 2), INDEX({DE},…
-
What formula would I use to read a date from another sheet?
I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going…
-
COUNTIF matching instances, or alternative IF(ISBLANK workaround?
Hello! I'm struggling with syntax and can't figure out why this isn't working. I have two columns [Total] and [Inspected]. I'm using countif in the first row of [Column4] to count the number of instances both columns have matching values, but it isn't giving me the correct count. Eventually, I'd like to build upon it to…
-
Calculating Days Elapsed Against Status
Hi there! I have been searching through everything in the community and haven't quite found an answer to what I am looking to do. Currently I am trying to calculate the number of days a row stays in a certain status [I have 5 statuses: New, Under Review, Needs More Info, Promoted to 12 Months, Not in the next 12 Months]. I…
-
Want to verify cells are equal, but getting reversed 'true' 'false' values in IF() statement...
I have a large SmartSheet that contains deposit information for my company plus others we do billing for. Since payments come in long after the service date in healthcare, I may get an outlier payment for a company that is no longer active in current year, but need to process. I've created a cell 'All Deposits' that is the…
-
using index/collect to gather data from 2 sheets
Hello - I have several budget sheets that use an "index/collect" formula to grab information from a master data sheet. However, we are now moving some rows from the master data sheet to an archived master data sheet. Once that row is moved, all of the index/collect cells are broken since the original row with the data is…
-
Date Modified
I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific date. I have a Report that uses the 'is greater than-date modified' but I get results from all…
-
Nested formula to present the most recent KPI value from a row
I am trying to pull the most recent month's value to the 'Current Month Data' cell to use for Dashboard Widgets that will only present the Goal and Current Month Data. There are 30+ KPI values that need to have the latest month's value, and I'm stumped on how to build the nested formula to make it work. The same formula…