-
Is Adding COUNTIFS possible?
I have a formula that looks at counting all instances where a certain unit in a hospital entered certain data into a master sheet in the last 7 days: =COUNTIFS({K Cards Range 1}, "High fall risk", {K Cards Range 2}, "FALL", {K Cards Range 3}, "GMH", {K Cards Range 4}, =[Facility and Unit]30, {K Cards Range 5}, AND(@cell <=…
-
Expected behavior for DATEONLY when embedded in other functions
I feel like the formula below should function to remove the timestamp off of the cell in created at the same row as the function, then count all cells in the created column in which the days are the same. =countifs(created:created,dateonly(created@row)) Currently this formula counts when the date AND time match. In fact,…
-
COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0 =COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed") Anyone help!?
-
What is the best way to identify exceptions to a sign in/out worksheet?
I'm creating a sign IN/OUT sheet and am trying to build a formula that checks a checkbox if there is not a corresponding "Check Out" to a "Check In" based upon the guest's email. I need help building the formula to match the following logic: If email AND created on date match AND there is not a Check In AND Check Out…
-
Formula to lookup a value based on criteria in 2 different columns?
I am looking for some help with a formula on my Roll-up sheet. I want to pull the Score by Site for the different years based on the information populated in my Data Sheet. Criteria #1: Site Name (e.g. Chandler, Chicago) Criteria #2: Year (e.g. "2018", "2019", "2020") Data sheet: Roll-up sheet example (where I'll plug in…
-
Reporting and Dashboarding on Multi-Select Column Type
Hi, bear with me as I am a pretty new user to Smartsheet (love the tool so far but have hit a snag) I'm currently utilizing the multi-select column type for a few of the sheets I'm working on. I love the feature, but am having trouble building the exact dashboard I need to report on my multi-select column. Let's say I have…
-
SUMIF Formula for text criteria in a column
Hi Smartsheet Experts! I'm sure this is a simple question, but none of my attempted formulas have panned out. I am trying to create a function that will count the total number of a particular condition in a column. I've included a screenshot below. So. What I'd like to be able to show is the total number of "ESI"…
-
Can I create one Smartsheet QR code that shows me a list of Forms to choose from?
Currently, my team has several different forms that we use to track process KPIs, or to populate other files. This means we have to post or carry around a handful of QR codes linking to those various forms. I'd much rather have one QR code to rule them all and show all the forms, click on one there and have it navigate me…
-
If Statement for Contact in another list and a flag is raised
Hello Again, I am trying to have a value populate (Which is a contact) if another contact is part of a list and a flag is raised in that same row. Some background if that wasn't clear, I have two sheets, one where employees submit if they are out of office, it has their name and the person to cover, as well as the date…
-
Multiple Values Filtered to One Cell
I am fairly new to Smartsheet. I am wanting filter data from one sheet to another capturing multiple values in one cell. I have an associate listing with the hardware they are assigned to. They may have several rows with different hardware. I want to see their hardware in some sort of summary sheet in one field (ex.…