IF function 100% Complete

Hello,

I'm trying to figure out using a symbol column type, once the visual symbol of a checkmark is selected, to then have the % complete column populate "100%". I can't seem to figure out the correct function to apply to all cells under the symbol column to automate this action.

Any help on accomplishing this is greatly appreciated!

Find more posts tagged with

Formulas

Comments

JoeC.

Each symbol is associated with a word, so you can just check for that value in your formula.

Therefore, your formula in the % Complete column would like:

=IF(Status@row = "Yes", "100%")

Paul Newcome

If your % Complete column is formatted as percentages, use the formula above but change "100%" to 1 (no quotes).

mmac

Thank you for the help! That formula worked perfectly. However, it does not seem to work if I have the % Complete column enabled under dependency settings. Is it possible to keep the percentages of tasks complete rolled up under the parent rows, still having the dependency settings in place, but also be able to have the percentage change to 100% once the status is set to Yes?

Paul Newcome

You cannot put formulas in the parent rows of any columns used for your dependencies. The parent rows are automatically set as a summary, but the child rows can only contain percentages.

You would have to select None as your % Complete dependency column and use the formulas already provided for the child rows. You would then use an AVG function in the parent rows to have them contain a summary of all subtasks.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…