-
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…
-
Why sheet requires saving when nothing changed?
This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus when I now click on another sheet, a dialog window prompts me to confirm to save my…
-
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"…
-
Combining cells from one sheet into a single cell on another sheet
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Column3]1). In sheet2 I only need the info from Column2 and Column3. Is there any way to do this from a…
-
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".
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
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],…
