-
Nested if for RYG Balls and qty not working
I am trying to use the RYG balls when noting when a variance has gone over certain amounts: 5000 or less - Green 5000-10000 - Yellow over 10000 - Red I can add grey as my false statement if the coordinator has checked off the completed box. This is the formula I have tried to build so far but I get the Unparseable error. I…
-
Can i remove multi-select from single cell?
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when employees work 1/2 a day and also 1/2-day Holiday or 1/2 day unpaid, on the same day.…
-
Best Formula to use to COUNTIFS based on several criteria.
I'm trying to come up with a formula that will return a number based on several criteria. I have a separate sheet that I have a key of allotted days off for each area (Vacation, Personal, Summer Friday, and so on). On that separate sheet, I have an available days based on the Key, minus the formula that i'm trying to…
-
Nesting SUM, Decimal places, and %
I'm attempting to calculate the percentage of work that's done, round it to a whole number, and add a percent sign. I can get 2 of any 3, but not all three. =SUM(([Points Done]@row / [Total Points]@row) * 100) Adding + "%" to the end of the equation gives me 5 decimals. I'd also like to add an IFFERROR for when there are…
-
Inventory Barcode Scanner / Expiration Date help
I made an inventory grid. One column has a barcode and one column has the expiration date. The expiration date reads the last 8 digits of the barcode to output a string of numbers that is the expiration date. Is it possible to make it formatted into a date like "dd/mm/yyyy". Right now it looks like this "ddmmyyyy"
-
Create formula to count category risk with aggregate rating
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
-
COUNTIFS & #INVALID REF Error
Hi! I built a rollup sheet with the following formulas. They work, but when a row is deleted (probably added too), the formula on the reference sheet the rollup sheet causes the #INVALID REF error. I have to manually edit the formula to get it to work again. One section has about 50 rows and 3 columns of formulas.…
-
Can i reference a workspace in smartsheet formulas
I am currently referencing 3 ranges off a sheet as per attachment. I have a workspace which has many sheets with the same structure. Can I reference the workspace to pick up all the same data? If so, what would be the formula?
-
Inventory Management
I'm trying to find a way to remove inventory when an order is sold, other than manually changing the numbers. I have a form set up to add new orders to the bottom of the sheet. I need a formula to automatically remove the inventory items from each line in the Sold column. Example: Customer #1 bought 5 items of my Stock #2.…
-
Lookup/CountIF Formulas for Multi-Select ranges
Hello, We are referencing another sheet and are wanting to know how many times the word "SNAP" appears in the multi-select cells within a row. Right now, this is what we have, but it won't work. We have tried multiple different formulas as well and cannot seem to find anything to count the number of time "SNAP" shows up in…