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?
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
