-
Highlighting duplicate data based on two conditions
Hi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country on the same date. So, if two (or more) cells contain the same date as well as the…
-
Doing two things in one IF statement
WHAT I'M TRYING TO DO: I would like to accomplish two things in one IF statement. Something like: =IF([This Column]@row = 1, [That Column]=true ALSO Today(), ....) WHY I'M TRYING TO DO THIS: I am trying to automate the Actual Finish column in my project management sheets such that, when % Complete reaches 100, then check a…
-
Help index and match?
Hi: I have a sheet (target) which has a project ID. I have another sheet (source) with 100 columns (which has the project id) I want In the target to take about 20 fields from the source and put into the target. Vlookup is limited as it can't handle more than 20 columns. and I can't find an example MY field is called…
-
Count all cells in a column that are NOT blank and do NOT contain a date
Hi, I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.
-
Any way to use a cell value as a row number in another cells formula?
Hi all Anyway to get the row # from a cell value and use it in a formula? Example this works: IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1) Now let's say Column1 row 23 contains the value 974 I would like to do this: IF(COUNTIF([Assigned To][Column1]23:[Assigned To]@row, [Assigned…
-
Making a decision tree in smartsheet?
Is it possible to make a decision tree type project in smartsheet? For example, I need to decide between options A, B, and C that have different cost implications and dependencies, but also need to plan for the potential staff and cost allocation. As an analogy, let's say a piece of equipment is breaking down, and I'm…
-
Checkbox and IF statements
Hello having trouble creating a formula and not sure if it is possible So I have two sheets first with 5 check boxes and then a value field. The second which holds the values. I want to be able to check the boxes and then have the value field add up the total example Sheet 2 values = These values might change over time…
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
-
Help with a Formula
I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing dates). I've included the formula below that returns the result of what your target %…
-
Formula Help!
Hi there, Would someone be able to help me with a formula that would be able to calculate the Fiscal Year based on a Finish Date of a project? FY19 - Feb 2018 - Jan 2019 FY20 - Feb 2019 - Jan 2020 FY21 - Feb 2020 - Jan 2021 Thanks so much!
