-
IF formula to change cell color if checkbox is or isn't checked
I'm looking to create a formula to change an individual's cell color if the checkbox for the cell is checked. I've tried different formulas but can't seem to get it right. All columns in the specific sheet include checkboxes. If the checkbox is checked, I want the cell background to be green. If the box is unchecked, I…
-
Referencing another sheet in a Countifs formula, if sheet is blank, erroring "#INVALID REF"
I have 2 instances where within a single folder I have one sheet counting occurrences in another sheet that is in the same parent folder. In the first instance, the sheet being counted has existing data, and when I "Save as New" everything works as expected. In the second instance, the referenced sheet is blank and when I…
-
Formula to determine duration based on a certain status
Fairly new the smartsheet, so bear with me. I spend a lot of time in these forums learning, but have not quite been able to figure this one out. We have an intake sheet for project requests. We are tracking the date the request comes in and the date that we Close out a request, so Open and Closed statuses. However, there…
-
Using a Form and having it auto child to an existing Parent
Hi there, We use a form to input training files. For example Bob C- Analogs passed - Date If Bob C already exists due to previous training, if there a way to have Smartsheet automatically child the next Bob to the existing Bob C after it is entered? Additionally will Smartsheet also recognize that if Jake S had 2 entries…
-
confusing formula results.
I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae. I've written a column formula to add the values in two of these vlookup columns and in some of the cells I get the expected result, and in some I get a #NO MATCH error. I can't figure out what is wrong here. I've reviewed the data…
-
COUNTIFS when Referencing another Sheet
I am making a dashboard and have created a Calculation Sheet that will link to the Dashboard. All of my calculations reference other sheets. Most of the formulas have been simple thus far. All I have been doing is counting when a certain symbol shows up in a column using COUNTIF. For a specific sheet, I have multiple…
-
How to use Countifs and AND and Ors
I am trying to make a chart that will count how many projects an employee is on given a certain criteria. Based off of my master project list sheet, I want to know how many projects my team members have each quarter (active and upcoming) I would like it to say count if employee name is employee@row AND Project Status is…
-
Index Match for Multiple Options
I want to set a formula that will index match the value(s) of a cell with a reference list of group name and associated contact information. Is this even possible? I have Sheet 1: list where each row has an entry that states in one cell, multiple group names I have Sheet 2: list of contacts by group name I want to have…
-
Limit Dropdown Options Based on Cell
If there is a quality answer to this someone can point me to, feel free to link it. I've searched but find none other than that this has been requested for some time. Here is the setup: I have a dropdown with "Stage"; It has the following Values and is limited to one of these values. I have another Column for "Status";…
-
EOMONTH similar
I am trying to automate the Month/Year field to add one from the pervious cell. Excel formula: =EOMONTH(E13,1) Is there any work around in smartsheet?
