-
How to use Formulas to change the value of Symbols and Check Boxes?
I'm kinda new to this. I'm a little familiar with how formulas worked in Microsoft Excel, but not a pro in the slightest. I only know basic stuff. How do you use a formula to change the value of symbols and check boxes and drop down menus? Also, I've been having trouble pulling the data from dates. I always get the…
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
-
Using Parent / Children functions to roll up dates
trying to add new columns to show some milestones end dates on the parent row. For example, if i have a summary parent row called "Project 1" and one of the child tasks called "SOW", i want to show the SOW date rolled up to the summary row in a new custom date column using formulas. Any idea how to do that? Not so sure how…
-
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%…