-
IF Date formula
Hello- I am trying to write a formula for an approval process that if the first approver has approved and if the second approver has not responded in 7 days from the first approver date, there is a checkbox that gets marked. I am just not sure how to write it. Does that make sense?
-
Index/Match Returning No Match When it Has A Match
I keep running into issues in one of my SS environments where the Index Match function is returning a #NO MATCH. What's interesting is I will have it in one column in a sheet and it works, then in the next column I am using the same formula but the only difference is I am changing the INDEX range which then produces a NO…
-
Formula Help - Counting Multiples as 1
Hello - Need some help figuring out the correct formula to use for what I need. I've put a sample data table below. Essentially, let's say I have a sheet of requests that I need to to track by category. 1 category may have several rows but I only need to count 1 for any of that category that have an unchecked box. See data…
-
Need help with formula for adding days to last day of the month.
Hi there! I'm trying to create a formula that calculates a due date based on a certain number of days after the end of the month, quarter, year, etc. I wasn't able to figure out how to show the period end date without manually entering it. So I created a formula that looks at the current month and returns the last day of…
-
Lookup or Data Mesh for values based on 2 criteria
I have a sheet that I'd like for it to enter a value based on 2 criteria, Site and Job. John Doe gets hired for Job 3 at Site 8 ($131,040). Is there a formula for Smartsheet to enter the value based on column and row data? Or is there a way to set up Data Mesh to lookup this way?
-
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…
