-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
IF AND CONTAINS Formula with Multiple Criteria in Another Sheet
I'm trying to pull data that meets multiple criteria from a master schedule into a separate individual schedule. If the data meets the 3 criteria, the cell populate with a value from another cell. I've tried many different formulas but haven't had any luck. The image on the left is the master schedule and the image on the…
-
Smartsheet Summary
Hello, I am wondering if someone can help me with the syntax to get these to work: =COUNTIF([New User Certification Check]:[New User Certification Check], "#NO MATCH") =COUNTIF([New User Certification Check]:[New User Certification Check], "New User Certification") both of these attempts result in #NO MATCH in the sheet…
-
Paste as Values Automation/ Function
Hey all, I'm wondering if there is some way to automate the pasting of cells as values across entire columns or sheets. We currently have an archiving process that involves rows on an intake/tracking sheet and another "roster file" associated with that row. These two things have cell links between them but need these links…
-
Date format - Cell linking
Hi, When I try to cell link a date column it changed the date format from: dd/mm/yy to mm/dd/yy. The strangest thing is that it did not happen most of the rows, but some random ones. I have tried to refresh the sheet several times, but I still get the same date errors. Do anyone have any idea or suggestions in order to fix…
-
COUNT IF - Multiple Columns
Hello, I am trying to use countif based on multiple columns for a calculation sheet for my dashboard. I am trying to compile a calculation based on the "site name' and if the items for that site are overdue or not. For example: I want to pull from these two columns below into my calculation sheet So how would I set that up…
-
IF(IS BLANK) - Multiple yes no criteria
I am trying to find a way to have this function look at 4 different cells and if any of them are not blank, it want it it say, "yes." If they are all blank, i want it to say, "no." I guess I need 4 of these strung together with OR. But I can't make it work: =IF(ISBLANK([Outstanding Audit]@row), "No", "Yes")
-
Count items in multi dropdown list
Hi everyone, I am trying to count items individually from a multi-select column in a sheet called "Other Sheet" by adding the following formula to a separate sheet: =COUNTIFS({Other Sheet}, CONTAINS("Value 1", {Other Sheet})) It's not working, and I am getting "0" for all the items (which is not true). Any ideas what's…
-
Active Cell and Summary
I would like to use the Sheet Summary to add a few key fields that reference different cells, depending upon what the active cell is. For instance, when the active cell is C40R272, I want the summary field to return the value of C1R272; when active cell is C40R473, the summary field would return C1R473. Similarly, when the…
-
Workflow and/or Formula for tallying daily asset inspection issues
We have daily asset inspections that are submitted via a form and I'd like to: Create a daily Workflow that will send only the assets that had an inspection issue on that date, as well as the issue description. (Columns are: Asset, inspection yes/no questions, and description of issue) . Rows are each date an asset…
