-
Count + Contains formula question
Hello! I'm having trouble with a formula in a sheet summary field. I have a column called "Service Type" where I want to count the number of entries that contain QA. There are multiple QA entries, some say QA+, some say QA5, QA10 or QA20, QA25, etc. to give you an idea. The common denominator is the QA, so I want to use it…
-
Progress Bar and/or Completion % by Check Box Column Status
Hello! I'm looking to use a formula that will calculate the percentage of tasks completed by row based on whether or not the check box is "checked." I have five check box columns, so if one is checked, the % Completed column shows 20%, if four are checked, 80%, etc. I know I need to use IF/And statements, but I keep…
-
Need a formula to recognize a checkbox and match it to a name
I work in a property mgt department and we've built a room inspection form. Our suites have rooms assignments based on the bedroom within the suite. The columns for the form are broken into sections of columns but I have the rooms assignment rosters broken down into rows. I need a formula that will recognize the box is…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
-
VLOOKUP with multiple criteria help
Hi, I have a sheet which has 1 column showing a document name, and another column for document revision number. I need to make a vlookup which returns the owner of the doc, based on the document name and revision number. I'm aware that the simplest option is to concatenate the two columns but I'd prefer not to add another…
-
Contact column to return multiple email addresses
Good morning, I have a contact column, then an email address column where I use a Vlookup function to go to another sheet and pull the users email address from. However, when I enter multiple contacts I want a formula to return ALL those email address back to my email address column. I know VLOOKUP isn't it, and I tried…
-
Avg collect Error
Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formula I had been using which has worked well in 2022. However, now that I'm attempting to collect the avg score from the same…
-
Index & Match formula
Hi Smarties, I have a question on Index and Match formula. I am using the Project Management Office template set from Smartsheet. Based on the Intake sheet, a new project is created, and a number will be auto-assigned (SM-004) I made a few changes by adding in Project Type between Project Name and Project Manager. In…
-
SUMIFS in Smartsheet
Hi all, I'm trying to use SUMIFS in Smartsheet to sum actual hours for individuals between two dates. I'm using two sheets, one is the front facing table and the other is the raw data. I've tried this forumla which worked in excel, but won't work in smartsheet? =SUMIFS(sum_range, individual_range, criteria1, date_range,…
