-
Invalid value (Problem with RIGHT, SUBSTITUTE and VALUE Formula
Hello, As the picture below shows, I am trying to extract 2 numbers from a cell that displays different formats (paper sizes). I need to set up a calculation with the 2 numbers. That is why I use the LEFT and RIGHT Formula to extract the text and the VALUE formula to change it to number format. I also use the SUBSTITUTE…
-
Looking for Nested IF formula support, unless that's the wrong formula set...
Looking to get specific terms to auto-populate the "Production Status" column, based on where the current Actual production line up is done to. For example, if a date is entered (manually) for Capping Actual, then Production Status would say "Capped". If IVT/ Uncapped Actual had the last date it would say "IVT" for…
-
Issue with Account License from Business to Team
Hi Community, I'm looking for some help with a license issue we're having. It appears our license has been downgraded from "Business" to "Team", which has restricted all our functionality (i.e. workflows, forms, notifications, alerts, new sheets etc) about 5 days ago. This is causing some serious business disruptions with…
-
Merged: Strikethrough, for selective text
This discussion has been merged.
-
How to remove NA from Calculation
Hello, I am currently using the formula below to get a percentage complete calculation, one of the parameters has the option for NA. How do I include the NA in the formula to make it so it doesn't affect the percentage? It is the bolded parameter below: =SUM(IF([Paperwork Received]1 = "YES", 0.2, 0), IF([Samples Received]1…
-
If there are multiple batch numbers, how can I make that go to different rows instead of columns?
Hello, I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row? Right now…
-
automated alerts triggered by number of entries
Hi, I've been asked to help with a form. They'd like to cap the number of entries at 100, and I'm not sure that can be automated. They'd also like to receive alerts after 25, 50, 75, and 100 forms are submitted and new rows are added. I see a way to get an alert after certain dates, but not in the number of entries. Is…
-
Keep getting this error when I try to request the "User Group Attendee" badge.
I keep getting the above error when I try to request the User Group Attendee badge. Not sure why. I've been to a couple User Groups now & I registered for them, so if it's a matter of an attendance list I should be on them. I'm able to request other badges, it's just the User Group Attendee one that's throwing me this…
-
Countif / Countifs values are between "0" and "10"
Hi all, Struggling with a formula and could use a hand. I'm trying to display data which shows me how many values are outstanding between 0 and 10 days. I've tried a few formulas but none of them seem to be working, which is driving me insane! =COUNTIF({MS - Range 5} < 10) As shown in the above, i've even tried to simplify…
-
Formula for counting how many people have signed in each month, referencing another sheet?
I am trying to count how many people have signed in for each month referencing another sheet so that the number appears on my metrics sheet. The below is what I have at the moment but it isn't working: Trying to find how many people signed into Yard A in January 2023: =COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1,…
