-
Multiple Match Criteria
I'm working on a formula to return an account number if the criteria matches for Client AND Service Description. For example, if a user selects Medical Education from a Service Description dropdown list when creating a work order for Client X, the corresponding Medical Education account number for Client X should be…
-
I am trying to write a formula that will count if a specific word is mentioned in a formula.
I am trying to write a formula that will count if a specific word is mentioned in a formula. =COUNTIF([Queue Name]:[Queue Name], "*INBOUND*") It returns zero with or without the "*" in the quotes. I know this works in Excel, but not sure how to make it work in smart sheets. The column will have words in front of or behind…
-
Enhancement Request: Hide formulas from Viewers in Reports
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas. Or tell me why this is a good feature.
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
Formula to tick a checkbox if the checkbox in the following row is ticked
OK - so I have a sheet that gathers weekly report commentary and I need to generate a report that shows the latest commentary, and the previous commentary entry. Have a helper column with the created date in to tick an 'isLatest' checkbox for the latest entry - =IF(Created@row = MAX(Created:Created), 1, 0) What I now need…
-
COUNTIFS where one criteria includes HAS
Good morning, Community! I could use some help with a formula. The yellow below should return a count from the **CBO CBA Case Tracker where (1) CPA Provided includes the CBA Provided sheet and column for that cell AND (2) if the CBA Provided Phase column on the **CBO Case Tracker sheet is Phase 1. I'll copy and update the…
-
Need a formula to display a final test result for multiple text values
Hello, I need help with creating a formula to calculate a "final test result" for the following scenario: 1) If any cell in the row is “FAIL”, then result is “FAIL” 2) If all cells in the row are “PASS”, then result is “PASS” 3) If one cell is in the row is “N/A” or “blank”, then result is “INCOMPLETE” 4) If all cells in…
-
Including child rows in filters
I have a follow-up question to a question I asked earlier today about including parent rows in a filter. Now I'm wondering: is there a way to create a filter and include the matching rows' child rows (when the children don't match the filter criteria)? So say I created a filter for all rows matching "teaching/mentoring"…
-
Return "Yes" or "No" in IF statement with multiple criteria - check if date is past due
This one is proving difficult for me - trying to create a helper column that does the following 'IF (deadline cell) isn't BLANK, AND (status cell) is one of "Active" or "Closed", AND (deadline cell) IS in the past return 'Yes" (past due), otherwise "No" Would love there to be a way of doing this as a summary sheet field…
-
FORMULA(S) ERRORS
I have been trying to "MATCH/NO MATCH" values in sheet A with Sheet B. first by columns to ensure data integrity then to do a formula that will return MATCH/NO MATCH if all criteria is met, with an "@cell " formula to match =IF(COUNTIFS({PAYEE}, FIND(Payee@row, @cell) = 1, {DATE}, FIND([Invoice Date]@row, @cell) = 1, {INV…
