Using a formula in RYGG but it disappears when used manually


I have a Contract Health column in my sheet to note the health of a contract which would be a manual process to move from R, Y or G. However, if the contract is closed, I wanted it to check the "Expired" column and then to automatically revert to Grey. I copied the formula down but when I made the row Red to test I noticed the formula disappears. Right now I don't have KPIs that indicate what RYG mean. Once I get them I could create a column where they would note something like "client unhappy" and if it shows that then the status would change to Red but right now I don't have that. What suggestions are there to be able to manually change the cell RYG as necessary but have it automatically change to Gray when the contract is closed?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!