-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
How do you create a formula that calculates weeks out in certain cells based off one cells date?
Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working. I have a target end date and i want existing cells in a "task section" to calculate the weeks out based off that date
-
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated. On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula. On the source sheet I have a "Task Name" column, an "Audience" column and the "Description" column I want the data from. Unfortunately, the…
-
Inventory Management
I'm looking to create a sheet to manage our department's inventory of swag/give-aways. I currently have the asset management template set up and running and am using the barcode functionality which is mostly serving our needs. The one gap I have is inventory updating. Ideally, when someone takes inventory, I would like for…
-
Referencing the Row Above in a Formula
Hi all! I am trying to create a formula that compares 2 values in the same column. One on the current row, to one on the row right above it. Every row represents a separate week, and I want to compare metrics from the current week, to last week, and based on the result (>,<,=) a symbol will appear. I found a post where…
-
How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
-
Automation creates duplicate row instead of updating it
Hi All, I was trying to set the following flow and it doesn't seem to be working Master Sheet - copy row to Project Plan (several conditions) = working fine Master Sheet edit row - edit a relevant copied row in Project plan =/ not working, creates a duplicate row with updated info --- is there any way around this? feeding…
-
Deleting Cross Sheet References // Reference Manager
Anyone else not able to delete Cross Sheet References? I have a total of 8 CSR's that I have Deleted multiple times...but they keep showing up again in the Reference Manager. I even deleted the column in the source sheet that the reference was pointing to and they still won't completely delete... I submitted a support case…
-
How to link only to parent level data in source sheet?
Hello, I am wanting to link cells so that the column in my destination sheet contains only the data in parent-level rows on my source sheet. Right now when I link and highlight the source column, it pulls in the indented levels also. Or it will leave blank spaces in my destination sheet where the source sheet may have…