-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
How to select result from table of data?
This is a weird one that I couldn't find any help on. I have two sheets. On the first one is a bunch of data and formulas, but the end result is a column with the number of miles each person has walked. The second sheet has a list of cities, along with their miles between each one and a cumulative number of miles for the…
-
Combined IF AND formula with range
Good afternoon, I am trying to return values in a cell based on data in another cell as it falls between a range Here is the range: 1 Star 299 - 966 2 Star 967 - 1160 3 Star 1161 - 1330 4 Star 1331 - 1509 5 Star 1510 - 2300 I've gotten through 1 Star and 2 Star but am receiving an error when I try to tack on the next range…
-
Pull Most Recent Invoice Data for An Account Using INDEX/MATCH/VLOOKUP/MAX (Or Other)
Greetings! Our team uses a Smartsheet to track monthly invoices for each client. Each invoice date is listed separately for each client (see attached). We are interested in populating in another Smartsheet the date of the last invoice. For some clients, it might be 02/28/2022, for others 12/31/2021, or other dates for…
-
Fill Month Category From a Date Time Stamp.
Hi, I am wondering if there is an IF statement that can fill the month Category ( January, February, March, April, May, June, July, August, September, October, November, and December.) From a time stamp Column (April-7-2022) and If the date is within the range of the month of April it will populate the column category with…
-
Box checks automatically if criteria is met - formula?
Hi! I'm trying to get a ticket issue checked as 'resolved' when somebody fills out a certain field. How do I get smartsheets to automatically check 'resolved' when "self help recommendation" column is "I have tried this and found a solution". Any help?
-
Referring to a Previous Day
Can someone please assist in helping with a formula that will simply just refer to a value from a previous date? Example: Two Rows by two Columns. The top row has a date of 4/3/22 and in the Value Column it has 5. In the bottom row the date is 4/4/22 and in the Value Column it has a 3. If I wanted to add the two values…
-
Issue with #INVALID REF in formula
Hello, I am trying to create a calculation that will then be used for a metric widget on my dashboard. I want to be able to have metrics for different groups of projects by state. My goals is for the formula to only count projects that have "P2P(Department)" in the Department column of my portfolio metadata sheet. I have…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking…