-
I can't get my Index Match Max formula to work- has error #UNPARSEABLE
Trying to find replica of excel's Xlookup formula. Here is my current formula that is not working: =INDEX({GP% TO PAY}, MATCH(MAX({HIGHEST TIER%})([% to GP Budget]@row, {HIGHEST TIER%}),0)) I am trying to pull in Employee's % to be paid on their bonus, based on the current sheet's % to GP Budget result. The helper sheet I…
-
Filtering/Illustrating Data From Date Columns on Dashboard
I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each item filtered by year, and then each item has its own specific date on the sheet. What formula can I use to do this on a…
-
Cross-sheet COUNTIFS Formula Not Working as Intended
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the one I am trying to create to count the number of projects that are due this week. I need to formula to count the rows that…
-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
Getting a date from a "dropdown" column to a date "column"
I have a form people are able to fill out and select several dates from a list. I want to make it so I can run automations based on what they selected for a date but I need to make a formula to convert the dropdown list column dates to an actual date column dates (I already have it set up this way). Here is the dropdown…
-
Average of Color Symbols (RYG) on same row
I need to be able to create an average (In the Overall Status field) of the 3 filed to the right. As you Can see, they are symbols with the standard stoplight (RYG) colors. I have done this (with the help of the community) for parent/child, but now these fields are on the same row.
-
How to auto-create a new set of rows once criteria is met?
Hello, I want the following columns to auto-create (with the filled in colors as well) below the already created ones every time "SITE" gets filled in. Do I use a formula, conditional formatting, or some other way? Thank you in advance for the help!!
-
Formula problem
Hi! Before I start, I want to say that I'm still fairly new with formulas, so it's very very possible that this error just might need a slight fix, but I need a bit more assistance with what I'm specifically doing wrong here to get a better grasp of formulas. I'm trying to get a sum of how many tasks my vendor has…
-
Bring in data to new sheet
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removing the cell link and redoing it each time. Here is the source sheet screenshot:
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…