-
Updating current formula from counting days to counting business days
Hello! I have been tasked with creating a formula that looks at the request type (drop down) and based on that, adds a certain number of business days to the request submitted date to give a completion date. There's 6 options, I was able to make the formula just with regular date counting, but now I need help in adding in…
-
INDEX/MATCH with a HAS Function for Multi-Select Column
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 like the High Priority flag marked if any/1 or more of the Sites Under Consideration are flagged a High Priority in the…
-
Combine 2 sheets into one
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 listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it…
-
IF Index/ Match Return Yes or No
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}. However, It is returning Yes across the board. My range covered 2 columns both in text. Do I need the range to be formatted…
-
Use countifs to count all projects with a quarter date and year from a date column
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 given invalid data type as an error
-
Countif Formula in Sheet Summary not giving results
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 I get a result and the sheet summary calculates if the box is checked using "COUNTIF". I was seeing the results in the past…
-
Help with a formula based on conditions
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 region (either US, CEMEA, LATAM, ASIA) AND the user has provided the Job Level. The salary should come from a different sheet (I…
-
How to use COUNTIFS by Week?
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}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())) For the Official Opening Actual, I am referencing another sheet. I am not…
-
Formula's Broken
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, "Name 1", Renewal Victories V2![Platform - BSG], "<>") I can't figure out why none of my formulas will work. I am trying to…
-
Reporting/dashboard on form entries
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 they get a referral. I have the sheet set to automatically date/time stamp each row as it comes in. The department heads are…
