-
How do I create a list of unique names when the column I am referencing could have multiple names?
I am trying to create a unique list of names from a list of existing names. In some instances the original list of names has multiple entries from a drop down, *James *Sam "Barry for example. I ran a query: =IF(COUNTIF(DISTINCT(names$2:names), unique@row) < 1, names@row, ""). This gave me the unique entries from my names…
-
How to use collect with a parameter
Hello: I have two cell, status and comments. I want a formula that brings the comment when the status is "Delayed". I am trying to use the Collect function, but so far, no success. Thanks
-
Data Mesh 4004 Error
I'm curious if anyone else has run into this Data Mesh error, and if they understand why it occurs: I receive this error periodically on multiple configs. It doesn't happen often enough that it has caused any noticeable issues, and I've never seen it happen two times in a row, so this hasn't impacted our users. I want to…
-
Assistance with Formula for Faculty Course Counting
Hello, I’m working on a formula and could use some guidance. I have a list of faculty members who each teach multiple courses throughout the semester. My goal is to count each faculty member only once while summing the total value of the courses they teach—but ensuring that each course's value is counted only once per…
-
Help generating project numbers
I'm trying to generate project numbers based on the order in which they were approved. I've tried using the countifs function but of course it renumbers my project numbers based on the position of the row. I've uploaded a screenshot to give an idea of what I'm looking for the end result to look like. Any help would be…
-
Can forms show on the navigation bar so users can pick one to use
Hi All, I'm trying to make my forms behave like templates that other users (admin permissions) can access by seeing them in the navigation bar for the sheet we are sharing. Is this possible or is the only way other users can open them to submit info is if I email them a link? Thanks
-
Work apps error
I have created a work app and it is viewable on my desktop but when i try to view it on a iOS device it shows me “No chart data available” which is weird cause it clearly works on my desktop. I have assigned roles to view the dashboard as well.
-
is there a way to run a report on all cell history data?
I currently click on each cell for its history. How can I run a report on all cell history?
-
Trying to set up a Round Robin for techs based on project type and if they are not out on leave
Hello I have been searching for a way to auto-assign a tech in a round robin flow based on what type of project it is . i.e only persons A-N should be assigned to the following types Decom, Darken While persons O-U should only get assigned to (or possibly any project type above or below) Go-To, Downsize, Refresh, Build…
-
Rows randomly reordering
I use a shared sheet and the rows will randomly change. We've looked at filters and rules but nothing would trigger the changing of the rows. Anyone else having this issue?
