Need help with formula disappearing in status column.

CDGiggy

I am working on building a template that has a column for Task, Done, Status, Assigned To, Velocity, Start Date, End Date. The status column is a drop down with the options of To Do, Doing, Review, Implement, Done, and of course uncategorized. The Velocity is a drop down that has a series of numbers based on Fibonacci numbers starting with 0-13.

The formula I have is in the Status column and it is set to change the status to "Done" if one of two conditions are met. First if the Velocity Number is 0, then the status changes to "Done" also if the Done column checkbox is clicked, the status will change to "Done" here is the formula

=IF(Done@row = 1, "Done", IF(Velocity@row = "0", "Done"))

What I have observed is that this works if the status is at default, which is uncategorized, the moment you change the status dropdown to "To Do", "Doing", the formula disappears. What do i need in place to make sure the formula stays.

Below is a snapshot of the worksheet

Andrée Starå

Hi @CDGiggy

I hope you're well and safe!

Unfortunately, combining formula and manual editing is impossible, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Add a so-called helper column that you can change and always override other columns.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

CDGiggy

https://community.smartsheet.com/discussion/comment/335028#Comment_335028

This might work. I will see if I can mod the sheet.