-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
SUMIFS and referencing columns on another sheet
I've been searching the community and couldn't find an answer so hoping someone will see this and help.. I have a data sheet and am creating a calc sheet for a report. I want to look at the reference sheet, identify one "type" and then sum all the $ for that one type. I have tried different SUMIF/SUMIFS and I cannot figure…
-
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…