Change cell text depending on other column

BSL

I want to change the text in a cell dependant from an other column. For example: the column % complete has changed to 100% then the text in the status cell changed to 'Complete'. The conditional formatting is just for changing background and text colours not to change text in cells.

Atus Bartal

You should use formulas to change the content of a cell, in this case you set a condition with an IF formula.

For instance in the first row in your 'status' column: =IF([% complete]1=1, "Complete","Not complete") - its outcome will be "Complete" when the cell in the first row of '% column' shows 100% (=1). 

For more info check http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#logic

 

Atus