-
COUNTIFS and Date Range
Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/04/2019 to 30/04/2020 =COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2,…
-
COMPARE COLUMNS
Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1; false) and Match; =MATCH([NÚMERO DE SINIESTRO]1; {SINIESTROS CF}; 1) But i only…
-
Intersecting Contacts and linked data
Hi there, thanks for all the contributions here - I already have solved so many issues. I'm stuck on one and hoping someone can think of a workaround: In one row I have multiple contacts assigned in a contact type and I want to highlight the cell that intersects with another column. In this instance, its because I need…
-
repeat sum IF for mulitple cells
I have column "Location".. then many rows of citifies with lots of data for each city. I need to summarize my data "By Question" AND "Location" - however it does not work to "drag" or to copy paste. I have to change all my information in every cell... I have hundreds. Is there an easy way? In Excel, I could drag and it…
-
Auto fill cell value if adjacent cell matches cell in another sheet.
Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log. my main log: 1st column is RFI #, and 2nd column is internal…
-
Formulas for Column Dates to Autofill
Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to figure out how to set it up so that the Project Auditor Completion Deadline will auto…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Forms Logic
Good Morning: I am trying to find a way to implement conditional formatting to a form - based on a selection additional field would populate. When I looked on Smartsheet, it stated that you could do this under "Logic" within the forms design. However, I don't see "logic" as an option available to me (NOTE: I am in the…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…
-
COUNTIFS + OR
Each quarter completed jobs get moved to a Completed Sheet for that relevant quarter. However, some of the tasks done on that job needs to be reported for a previous quarter. An example of a task would be a Preflight Review, which takes place at the onset of a job, meaning the job is very likely to complete in a following…
