I am trying to create an INDEX/MATCH where the INDEX is a Checkbox column and the MATCH is a multi-select column. I am not sure how to incorporate the HAS function for the multi-select column. I would…
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is lis…
Hello, I am using the below to return Yes or No as true or false matches. I am looking to Confirm if the Contact listed in [Requestor Contact] is also listed in range {Covered Persons List Range 3}. H…
my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022" I have ensured the column from the reference is a date column, however I am gi…
Hi, Just wanted to check with the community if there was any change to the criterion selection under the "COUNTIF" function. I have a column formula for a checkbox column in a Smatsheet that flags if …
Hello, I need assistance with creating a formula for the following: In the Annual $ cell, I would like the salary to automatically appear when two conditions have been met: the user provided the regio…
Hi- I am trying to write a formula for how many locations have officially opened per week of this year. This is what I currently have and all it gives me is 0. =COUNTIFS({Official Opening Actual}, IFE…
Team, Am new to Smartsheets and am trying to create metrics sheets that I can then create reports and dashboards from. The formula I am using, for example is: =COUNTIFS(Renewal Victories V2!Agent, "Na…
Our Referrals departments has recently started utilizing a smartsheet form to track key information on each referral that comes into our hospice. Each team member completes & submits the form when the…
