- 30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
- How do I make this formula count blanks?
Hi, How do I make this count blanks? =COUNTIFS({Range 2}, "name", {Range 1}, "30 days", {Range 3}, "Ready Re-insp" {Range 3}, "ISBLANK")) I've tried Range 3}, " ")) Thank you Kim
- Branding & Personalization Colors?
Hi, I changed our colors in the Account colors but the new colors only work on new sheets. Is there any way to refresh the older sheets with the old colors to have the new colors? Thank you
- Formula countifs mulitiple criterion?
Hi, I can get as far as (made up example) =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass") but I need to get a third items to be count. For example: =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass", {Range 8}, "ready") Is it possible to search three different columns in a crossheet countifs? Thank you, I appreciate any…
- Subtract six months from a date
你好,我已经阅读社区卫生y but am confused. I have a date that updates a few times a year, let call that column A. I need column B to give the date six month prior to that date. So I need to subtract six month for what in column A. Can someone please give me some advice to do that. Thank you Kim
- automation setting question
Hi, I'm setting up an automation that remove anything on a sheet older than 8 months. What am I doing wrong? What is really weird is it pulling some stuff off the sheet to soon but not all dates to soon. It's very random what's moved. It everything in the wrong date ranged moved then I would assume it the settings. Thank…
- Data Mesh Only adding new information
Hi, I have one sheet of customer names and one sheet of customer information. Both sheets have customer ID's. The customer information is the source sheet and the customer name target sheet. I want information from the customer information added to the customer name sheet "only" if it a new customer ID. I want it to skip…
- Change the source sheet on Data Mesh
I've just started with Data Mesh and my only problem is not being able to change the source sheet. There is often new informational sheets I need to update and instead of having to make a new Data Mesh and delete the old one, it would be nice to be able to change the source sheet to reflex our changes. Thanks
- Change the source sheet Data Mesh?
Hi, is it possible to change the source sheet in Data Mesh? Or do I have to create a new Data Mesh? Thank you
- What are the Data Mesh Cell limitations
Hi, I know when I run Data Mesh there are limitation to how many cells can be updated but I don't remember how many cells are allowed. Does anyone know? Thanks Kim