Welcome!

Checkbox to equal 100% in % complete

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%")

Manufacturing

Formulas

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?~~

Indexing from Multiple Sheets
Good afternoon Smartsheet Fam, I'm trying to create an index formula across 4 sheets to pull into a single sheet. The formula I have tried is: =IFERROR(INDEX({AHM.Client}, MATCH([CU Project ID]@row, {AHMPlan.CUProjectID}, 0)), INDEX({ahmne.client}, MATCH([CU Project ID]@row, {ahmne.cuprojid}, 0)), INDEX({ahmse.client},…
Setting up a metric sheet to calculate the YTD sum, but not show data in future months
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
Count projects completed in a date range
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?