Trying to Clear a "Ball in Court" cell when item is complete

Help!

We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete.

Any suggestions for solutions?

Find more posts tagged with

Construction

Formulas

Project Management

Comments

Mike Wilday

Have you considered creating a Current User report that your users could use for current tasks? You can set up the report and exclude rows that are marked as complete. When you users load their report it will only show them incomplete tasks.

Kait Bankey

This report that we use this for is actually a published sheet that we send to our vendors each week, so it would be too difficult to set filters for them as there are too many hands/eyes on this that are using it for different reasons.

Mike Wilday

You could add conditional formatting to turn the text in the cell white... their picture would still appear, and the email would still abide in the column but it would be less visible. You could also dim the whole row or strike it out showing that its completed.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…