Prevent Formula Overriding

Hi there!

I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox.

The issue I'm having is that the formula erases if someone chooses a value from the dropdown/types in their own. This means that when the task is checked as complete in the checkbox column, the Task Progress column does not update to "Complete" and the user has to manually change it.

To try to prevent this- is there any way to set it to where a formula is not overridden by manual input? Thank you!

Find more posts tagged with

Formulas

Government

Product Development

Project Management

Comments

Andrée Starå

Hi Madison,

Unfortunately, it's not possible at the moment to have a formula and also change values manually, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround would be to have a formula that changes the status referencing the date and other cells.

If you still want to be able to change the value manually, then you could use the third-party service, Zapier, to change the value to complete, and it's not dependent on any formula.

Would one of these options work? Is Zapier an option for you?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Mike Wilday

Hi Madison,

As Andree stated, this isn't currently possible. If you want to automate the process you have to automate the entire process or not at all. Any manual adjustment of a field that has a formula in it, will overwrite the formula and negate it. To work around this our team automated the entire process. We created Actual Start and Actual Finish date columns and then used the following formula to indicate the status of our project.

=IF(AND(Isblank([Actual Start]@row), Isblank([Actual Finish]@row)), "Not Started", IF(ISBLANK([Actual Finish]@row), "In progress", IF(ISDATE([Actual FInish]@row), "Complete")))

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…