Improvement Feedback on Conditional Formatting

Nasir@EBC

Hi All

Please read my feedback on Conditional Formatting. I need your vote on how valuable this change would be!

 

FEEDBACK

The conditional formatting should allow us to create a condition --using another existing cell's reference. 

Example:

If "Fee Collected" is less than "Fee Due" then apply this format to "Fee Collected".

In the above example, "Fee Collected" and "Fee Due" are the names of 2 Columns. 

And here I wouldn't need to write a numeric value after the comparison operators (e.g., If "Fee-Collected" is less than 1000"); instead, I would just use another cell-reference (Fee Collected) whose values will be tested by the first cell (Fee Due) --each time a new entry is created!

Thanks

Nasir

 

Andrée Starå

Hi Nasir,

I agree and it's a great idea! It would be an excellent addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Nasir@EBC

Thanks Andree! 

I will submit it right away. 

 

Nasir

Andrée Starå

Excellent!

Happy to help!

ron.judenberg112096

There's an easy workaround for this.

Create another column with a formula containing the relationship between the two fields

=[Fee Due]@row - [Fee Collected}@row

Use the value in that column to drive the formatting.

Andrée Starå

@Nasir@EBC

✅Did this post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!