-
Checkbox cross referencing person on another sheet
I am looking for a formula to cross check another sheet to check a box on my cumulative sheet. Example, someone completes a required training on EM# 1 sheet then on the EM# 2 sheet I want that persons name to be checked from a list of other individuals. This is the formula I used, =IF({Emergency Preparedness Employee…
-
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…