-
Summary Formula to Show New Value Each Day
I have a sheet that tracks new employees by type. Within my sheet, I have a date column and employee type columns (example: Intern). I'd like to create a Summary formula within the sheet that will return the number of interns each day. Or a formula that will return the last entry in that column. How can I do that?
-
Cross Reference Countif Formula is giving Unparsable Error.
I am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31)) However, when I modify on another sheet to read as what is…
-
IF with multiple choices dropdown list cell
Hello everyone! English is a second language for me so please forgive my spelling mistakes in advance. I have a form with a multiple choice dropdown that populates one of my columns in my sheet. I want to do an IF to give a rating based on the answers. Here's what I got: =IF([Question]@row = "answer1" and "answer2"); 0;…
-
Multi Select column logic to return results for a separate multi select column
I'm very new so apologies if I can't make sense of my question. I want to create a formula that will take input from column 1 which is a multi select (about 5 choices) column type, and take input from column 2 which is a checkbox column type and then return results in column 3 which is a another multiselect column (about…
-
I have three checkbox fields and need to return a value in a separate, single field
I have three checkbox fields (Submitted, Approved and Rejected). I need to return a value based on which checkbox is checked. I can get it to work with the IF function separately, i cannot get it to deliver and value if two checkboxes are checked. Example: If Submitted is checked, it returns the value of "Submitted". If…
-
Obtain UPPER(LEFT with multiple FIND options
I'm very new to smartsheets and to function formulas. I have a list of server names and I'm trying to obtain the location from our naming standard. I got it to work for all servers that are Production, "pl" but now I have staging servers "sl". Example server names in my Hostname column: l1plservername nap2plservername…
-
Count dates within a specific range
I am collecting performance data for my project. I have a report that contains all of the data I want to analyze and report statistics on. I'd like to look through a column containing dates including some empty cells, and count how many cells contain dates within a specific range. I'd like to count cells containing dates…
-
Limit return value
Is there a way to limit a number returned in a formula? I have a simple formula that returns a percentage (for a completion rate), but I don't want it to show over 100% or it will mess up my averages when used elsewhere. So even if someone over performs, their completion rate should only still show 100%
-
COUNTIFS using an OR with a column hosting 2 variables
Hello, Trying to set this formula to count 5 items using vlookup. The issue I'm having with that of the TYPE column hosting 2 distinct variables. I am not well versed but believe this needs an OR option. Curious if someone might know the best approach here. =COUNTIFS({HUB ERP - Function}, "Data", {HUB ERP - Status}, "In…
-
How to find 2 values from a multi-select column for reporting
I am trying to count how many times in a smartsheet 2 values show up in a multi-select column. example: i have a multi-select column with multiple options and I want to count how many times "Drainage" and "Roadway" are both selected. This can be done with the filter in the grid using the "has all of" options. This is the…