-
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…
-
Divide by Zero Message and IFERROR formula
I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average. =AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No")) I attempted to…
-
SUM of Check Box IF Function that returns a value.
I've created several "IF" formulas on a sheet. An example of one is as follows: =IF([Kickplate Installation]1, "$42.86", ""). When the checkbox is checked, it does return my value of $42.86. However, I've also created a column to total all of the values returned. When I "Sum" the returned values from the formula, the "SUM"…
-
Changing % complete using a formula in another cell
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column with drop down values of Not Started, In Progress, and Complete. I would like to change the value of "% Complete" when I change…
-
SUMIF and WEEKNUMBER
I have a connector that pulls in all tickets closed after 1/1/2020, and the points associated with each. I want to sum up the points for all tickets closed each week. My formula is: =SUMIF(Week:Week, 1, [Story Points]:[Story Points]) I did some searching and found you can't sum on formulas, and added the 'Value' column…
-
How Do I Get Symbols to Show?
I have formulas in place to display based on differences between two rows. I am migrating from SmartSheet Commercial to SmartsheetGov and I attempted to copy the formula displaying a green UP arrow using this formula =IF([Formula/Value1]27 >= [Formula/Value1]25, "Up", "Sideways") but field just displays the word "Sideways".
-
Average Formulas
Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but I'm not getting any output. =AVG(COLLECT([Transit Days]:[Transit Days],…
-
Auto-Fill Rows of Data Based on Criteria
Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country selected, the fields below would populate based on the values from another sheet. Example, If Austria is selected then the…