-
Formula to fill in the information in another column
I have the RPs, OLH Assignments and System Roles added as a dropdown list. I am trying to find a formula that will add the OLH Assignment and System Role based on what is checked in the Associated RPs column. Ex: If "Clinical Manager" is added to the Associated RPs column, then "Clinical Supervisor Home Health Curriculum;…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
-
Need a Formula to Show if Current Month & Year (in a checkbox)
=IFERROR(IF(AND(MONTH(TODAY) - MONTH(Date@row) = 0, (YEAR(TODAY) - YEAR(Date@row) = 0)), 1, 0)) Hi I want to check the "Current Month & Year" column from the Date column if true, so I can roll reports and data for next year. Not sure if my attempt is close or not!! Thanks in advance.
-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
Trying to generate a list of people based on criteria
Hello! I am trying to figure out a way of generating a list for a certificate program through Smartsheet. The certificate program requires that participants attend 6 out of 9 webinars offered in a year. We ask registrants to register with their first name, last name, and email address. I am hoping to use the email…
-
Date calculations based on frequency
I am struggling to get a formula to work. I am trying to write a formula that will calculate the next date a review will need to take place based on a manually entered date for when the last review was done and the frequency in which the review needs to take place for that row. The review frequencies are Monthly,…
-
how to get the circle quarter symbols to change colour???
Ok so I am using the below symbols with a formula in background to be in different qtrs/ stages of a project.... Background Formula is: =IFERROR(IF([%]@row <= 0.01, "Empty", IF([%]@row < 0.26, "Quarter", IF([%]@row < 0.51, "Half", IF([%]@row < 0.76, "Three Quarter", "Full")))), "") However, I want to change the colour as I…
-
Formula Help
Hello Just wondering if someone could help me update this column formula. I need it to exclude the N/A status. It is currently a column formula column that flags any items that are past due from the End Date column. =IF(AND([End Date]@row < TODAY(), NOT(ISBLANK([Program Status Type]@row)), NOT(Status@row = "Complete")), 1,…
-
Count months in another sheet but only within a certain year
I have one sheet with dates listed (ex: 9/10/21) that range from 2020, 2021, and 2022. I'm using this formula to count how many are in each month: =COUNTIF({Head And Neck_Project Overview Range 1}, IFERROR(MONTH(@cell), 0) = 1) But I'd like to break it down by year so I'd like to find how many are in January of 2021 only.…
-
Create SUMIFS formula with a contact criteria in a multiple contacts range
Hi, I am looking for the right way to build my formula that makes a sum of a number column with a contact criteria in a multiple contacts range. Example: =SUMIFS({numberRange with hours}; {Criteria Range with multiple contacts}; Contact Name; {Range with Statuscode}; "In Progress") Check also the screenshot below. If I…
