-
Contacts Column Not allowing contact to be selected
I am a admin user and use a sheet to log communications. WE have a Contacts column where the staff member is suppose to select their name, as the person entering the data. However, when 1 particular user tries to enter their name, they receive the error below. The particular person's name has been added as a contact, but…
-
Can you restore deleted columns?
Can you restore deleted columns?
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Sort column containing dates in chronological order
· Problem: It is not possible to sort a column containing dates by chronological order · Use Case: list of annual leave for employees working on a project · Ideal Solution: Enable sort by: chronological order for a column containing dates
-
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
-
Multi-select Dropdown and multiple values
Hi community! Looking for some guidance please! :) I need a column capturing the number of specific job roles associated with project. e.g. Job Roles ---- Product Manager Delivery Manager Software Engineer Software Engineer Tester Tester I don't think this can be done via a multi-select dropdown with multiples of the same…
-
Need a space saving IF OR formula
I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can…
-
Merged: Update "Symbol" Set to Accommodate Color Blindness
This discussion has been merged.
-
How do I copy the info from the cell above if criteria are met in another column?
What I would like to do is create a formula that will copy the information in the cell above it if the 'X-code Details' is chosen in the pick list in the column next to it. If General Run Details is indicated, want the entry to remain. I know there has got to be an easy solution to this, I just can't find it and AI is not…
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
