-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
Why did most of my reactions dissapear, & why didn't my most recent ones get added to my count?
I had almost 10 upvotes (see the 5 upvote badge on the right) but now it says I have 2. Also, my most recent idea that I proposed has 73 upvotes & again, my count says 2. Why were my votes deleted, & why aren't the most recent ones counting? As you can probably tell, I'm a fan of the gamification on here. I love how it…
-
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…