-
SUMIFS with a date requirement included.
I have a Disbursement tracker, showing Request Status, Date Requested, Amount and Project. I have another sheet, Project Plan showing the summation of Disbursements by Project. I am currently using the formula below to summarize all Amounts that are disbursed. I am using my request status column and including everything…
-
Formula for Dates Calculation
Hello, I am trying to find out how I can create formulas for the below. Kickoff Date - Number of rows with a kickoff date by month? IE Count of projects in a column with a kickoff date in Jan, Feb, March etc Average days in IMPL - The average number of days for all projects. IE: kickoff day in my sheet vs current day for…
-
Check a box if
Hi I'm looking for a formula that check a box if information in one column is in another column
-
Formula to check a box depending on start & end date
Hi all, I have 2 date columns (start date & end date) and 2 checkbox columns (live & concluded). I want to have the checkboxes automatically check and uncheck depending on the dates. For example: I have an event that runs from 12/2 through 12/4. On 12/2 I want the "Live" column checkbox to check and stay checked until the…
-
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;…
