-
Any reasons why even though I am at 100% it shows as if it is like 10% visually?
I checked the reports where it pulls and everything is set up the same way as the other bars. any suggestions?
-
#invalid data type
Hi, I'm using formulas in my sheet summaries of multiple files. All work perfectly well, except on 1 more complex sheet, which contains the same columns. Example: =COUNTIFS([Activity type]:[Activity type], "Partner event", [Budget FY]:[Budget FY], "FY25") The activity type & budget FY columns are both list of values. The…
-
Does locking a column stop the formula calculating?
This discussion was created from comments split from: Locking and unlocking a Column with a Formula.
-
RANKEQ formula returning 1 for all rows
This discussion was created from comments split from: Help with ranking based on criteria (RANKEQ, COLLECT).
-
If Match Check Box
How do I write a formula to check a box next to an ID Number if that same ID Number is also present in another column? So Column 1 is ID Number to complete and Column 2 is ID Number completed list. Thanks in advance!
-
How do I freeze columns in a report on a dashboard?
I'm trying to include a report on a dashboard, but I can't seem to figure out a way to freeze columns when the report is on the dashboard. Is there a way to do this? Any suggestions are greatly appreciated.
-
Adding contacts
my team (who are not licensed users) are wanting to add contacts but it either will not let them populate the box (using copy and paste) or it will let them add a name but not a space between the first and second names. Any help?
-
Copying rows from one sheet to another after checkbox trigger - copying whole sheet
Hi, I have 2 sheets that I am setting up for inventory and ordering for my team. Sheet 'A' has a full inventory list, including a checkbox that will be checked when the inventory item needs to be ordered. After a row is checked, I want it to copy over to my Sheet 'B'. I will use sheet B then to track the order process. I…
-
Find if any string from a list of strings is present in a cell
Hi I have a sheet with a column "List of Tests" that has a list of test codes, e.g. row 1 = T101, row 2 = T102, row 3 = T103; this same sheet has another column "Selected" that has a check mark to show whether or not the test was selected. A second sheet has a column that has one or more tests listed called "Applicable…
-
Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc. How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list. or do i need to create a different contact list/column? if so, how…
