-
Free users can no longer use "send..." on a row
Hi, has something changed for free users with the send option at a row level? we have a number of admin users but also free users than will fill out details in a row and then click the row dropdown and select the "send..." to send a mail with the details filled out for that rown. Now when our basic (free) users select this…
-
COUNTIFS for each week of the quarter
Hi, in my job we gene edit cells and afterwards, we see which percentage of the population received the edit (range 0-100%). I am trying to track how many orders fall into which range (0,%, 1-9%, 10-19%... 90-100%) for each week of the quarter. This information is pulled from a master sheet where we keep track of all of…
-
Adding Customized Fields from a different form link
Hello, Is it possible to have additional field defaulted into a form. I'm trying to create a approval workflow in my forms . I want form 2 to be able to pull a few fields from form 1 after a submission is received from form 1. I want those fields to appear before I send form 2 out to a supplier. Is this possible?
-
Countif not working properly in summary sheet
I am attempting to create a sheet summary to summarize complaints. I would like the sheet summary to count the number of complaints by month. I have entered in this function for October: =COUNTIF(Month:Month, "October"). It is working properly. However I tried to enter this for September: =COUNTIF(Month:Month,…
-
Share a report without sharing sheet (grid)
Hello, I have the following Problem, hope somebody can help. I want to share a report with some of my project members, but they should not have access to the initial database in the sheet (grid). The report must still be active and allow the members to change status of some collumns. This change should be shwon in die…
-
V lookup in sheet summary
Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'Sheet A' even though I indicated 'Sheet B' for that field.
-
Automation Delays Today?
Is anyone seeing delays today in automated notifications?
-
Finding an Invalid Value Within a Text String
Does anyone have an EASY way of finding an invalid value within a text string. For example... I have a field that should contain ONLY letters. No special characters. No numbers. I know I can use a bunch of CONTAINS or FIND functions to search for each number/character, but that gets rather long rather quickly. I know I can…
-
Issue adding email address
Hi, Our organisation was merged into a new organisation, and I'm now trying to add my new email address to be the primary email address now that they finally closed the old email address. I tried to add my new email address, but it comes back with en error message saying that my new email account is already associated with…
-
Advanced Filters
I applied a filter to a sheet to take out specific rows based on a certain criteria. Once the filter is applied, only the rows that meet the criteria show. Is there a way to show the parent of that row? It would be useful to have context of where the filtered row belongs/comes from.