nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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.

Comments

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