Auto remove or change content.

richard_uy

Hi, 

When i'm input the date @ "Done_DP", "Down Payment" became green, how to setup a formula to auto remove "Due Date 1"'s content or change to DONE (Due Date 1 are drop down list with "DONE")

 

Thanks in advance.

Mike Wilday

Are you currently automating the Due Date? If you're manually adding that due date there is no way to make it automatically populate with Done. Is that Due Date triggering notifications or alerts? 

You could visually change the row with conditional formatting if the Done_DP is a date. Would that work?

richard_uy

Thanks Mike. 

Manually input for the Due date.

Mike Wilday

Yeah, you can't have a formula changing the date and have a manual input on the same field at the same time. 

Paul Newcome

But you could set up conditional formatting to change the font color of that cell to match the background color of the cell based on specific criteria (another column displays a specific value). This will not remove the data, but it will effectively "hide" it.

Mike Wilday

Sneaky. Sneaky. 

Paul Newcome

HAHAHAHAHAHAHA