-
I want to calculate the number of days using two date fields, and if blank use today.
I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know how many days from today - Build Start Date
-
Change Status Ball for Old Row Entry When New Entry of Same Name is Created
I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to…
-
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…
