-
Help with month end formula
Hi, I'm building a dashboard to track referral responses. The missing part of my dashboard is I need create a formula that gives the total for each category by month and year. I can't figure out what function I need to add the the formulas I already have to break down the total by month and year. The formulas I've built so…
-
#UNPARSEABLE (Nested IF) - SOLVED
SOLVED! It was a DAU/Picnic error! I was missing the row number after the column name. Apologies, I'm not able to delete/close the original question. ________ I have a column named "Complexity". It's a drop-down list. The options in the drop down are: Rudimentary, Light, Intermediate, Advanced. Might you please shed some…
-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
Formula to count total number of items selected in a column of multi-select fields
Hi, I have a column called Type, which I've set up as a multi-select drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created the summary field to do the count on the column, it only gives me the number of rows…
-
Cross-sheet formula with checkbox
Hello all, I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true,…
-
Automated date due to change in dropdown list
Hi folks! We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column. If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if…
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
-
Minimum of a certain range
Hello, I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around? This is my attempt, but it does not work: =MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
If Statement Plus Index(Match()
Hello Again Smartsheet Community, Hoping to get some help with this one. The project I am working on is essentially a group of people will submit a request, based on the submitter they will be assigned to Group 1, 2 or 3. Depending on the group there will be one of several people available to process their request. The…