-
Date Formula
Hi I am trying to count the number of items that are for a particular month and year. eg: I would like to count the number of items submitted for the month of Jan 2018 the column I am wanting to pull the data from is a date column
-
Formula Needed for Drop Down
Hi, I am looking for a formula that will allow me to limit the options seen in a drop down based of what is selected from another drop down. For example, Column A would is a State Drop Down and Column B is a City Drop Down but only shows the cities that are in that state. Is this possible?
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
Trying to get fancy with formulas - RYG with "AND" conditions
I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item. I want it to give a Red result if it is within a specific number of days of the due date and has less than 25%…
-
Sigma Level Formula
Good afternoon, Wondering if anybody knows how to enter the following formula that we use in Excel: =NORMSINV(1-(total defects / total opportunities))+1.5 into Smartsheet, we use it to calculate Sigma Levels. Thanks!
-
Sum column from form submissions
I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a new record is added at the top however the formula summing the "Sales Amount" is not being included. My formula is…
-
Checkbox Checked depending on text
Should be simple, but I'm struggling. Two columns Text Column that contains some text. Checkbox Column I would like a folmula for the checkbox column to check the text column for some text. If the text column contains the text, mark the checkbox checked. Can this be done?
-
Formula Question
Good Morning. I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am looking to accomplish. Let me know if you can help. One column called Program with drop down options of Service Expansion,…
-
Formulas...CountIfs I believe
In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome. I have two columns. Both are drop downs. Column Program: A, B, C Column Status: A, B, C, D, E Would like to create a formula that will count how many A's are in Program column WHEN Status column is b, c, or d All…
