-
How do I enter criteria to return specific results, but not using filters or dynamic view?
I'm curious if anyone has an in-sheet solution for this. I have a lot of data related to store information (store #, address, software versions, regional manager name, etc.). It encompasses all information about a store location and there are over 1800. Is there a way to build a sheet so you can type in the store # and…
-
How can I use one type in cells if the column is another type?
I need to use formulas on the top row and all following should be a checkbox. But when inserting a formula, a Boolean is expected. There a way to get around this somehow? Or can you suggest another way to implement the table?
-
Outbound Links Monitor on sheets
Since there is a set limit to Outbound Links on a sheet (25 millions) and for core sheets that hold information used in multitude of other sheets this number can be reached easily, it would be good (for admins) to have a visibility over the current number of outbound links and start planning/implementing measures to…
-
Possible to use cell linking for formulas?
I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adjust it. Is it possible to have a reference sheet that houses all the formulas and use some kind of link to reference the cell…
-
Cell Linking
Is it possible to link a column to another sheet vs just a cell
-
Unique dropdown values in cells from linked sheets?
I want to create a unique dropdown menu based on a link from another sheet. On the linked sheet, one column will have a list of IDs and the second column will have a names that are associated with one type of ID. Each name has its own unique row, and IDs may appear multiple times for a group of names. The linkee(?) sheet…
-
Cell linking from one cell to a column on a different sheet?
Is there a formula that updates sheet 2's column when I enter data on sheet 1's row? ex) If a daily update starts on sheet 1 when the data is entered/attachment is attached, can a date automatically enter on sheet 2's date column? Sheet 2 is a running sheet so the date that I want automatically entered would be put once in…
-
Drop down list from another sheet
I currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to keep the values in the contacts sheet limited to the known companies in sheet 1. I…
-
Auto populate date from helper sheet based on certain criteria
Hi All, Having a heck of a time with a helper sheet and formula. If I type in a date, ex: 1/31/2023, I would like another column to populate a date that is before that 1/31/2022 date The kicker is I need that date to be a specific day that I have listed on a helper sheet elsewhere (dates on the left "Board Meeting Dates")…
-
Anyone get Outbound Cell Links are Functioning but Not Displaying Properly?
What does this mean? Learn more just tells me about cell links, not why i'm getting this message every time I open a specific report.
