-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Can't see the Dynamic View menu option on Sheet
I can see the Dynamic View menu option on top of the Sheet. Other users cannot. Do you know why? They only see File, Automation, Forms, and Connections. And what must they do to see it as well? Thanks.
-
Please create a warning/error message for Sharing discrepancies
If a user is assigned sharing to a report (e.g. editor, cannot share) but does not have equivalent or greater sharing privileges in the base sheet (e.g. they are only a viewer) the user will have issues making changes in the report as expected… The owner/admin then has to remember to look for this underlying…
-
A 2-part formula question
Good afternoon Community, I'm working on a new summary sheet and have a 2 part question I need help on…Some background: I have a sheet to track our recruiting efforts and am working on a Summary Sheet I'll use to build a dashboard. PART 1 I need to count how many reqs are open each month. This would include any reqs that…
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.
-
Calculate Working Days with blank field
Hi there, I'm trying to calculate the number of working days on a sheet between 2 date columns ("Date Opened" and "Candidate Start Date"). However, if the "Candidate Start Date" column is blank, I want to calculate the number of working days between Today and "Date Opened". I was hoping someone could just check my logic…
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
How do we get one or more checked check boxes, checked value in one cell? I need to get checked %
-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
