Sign in to join the conversation:
I am attempting to do the following.
If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100%
Here is the formula I thought would work using task 4.of the project.
=IF(Completed4 = "Complete", "100%")
Found my error
The formula should have been
=IF(Completed4 = "true", "100%"
Here is another option.
=IF(Completed@row = 1, 1)
You will need to format your % complete column as a % but then it will load the actual % rather than text.
What if there are multiple status' that equal 100%? what would the formula be for that?
Hi i'm looking to a formula using INDEX and MATCH to refer data from two sheets. i have 2 source sheets sheet: "project" and "Archive projet". in each, there are same columns for projet number and contact name. i would like to refer the contact name in a third sheet with a formula that can find the contact name based on…
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has been…
Hi, I’m trying to set up conditional formatting in my plan and need some help combining two conditions. Scenario: If the T-Start Date is in the past, I want the date to turn red. However, if the Status cell is Green, I want the T-Start Date to show as green instead of red (so the Green status overrides the red formatting).…
