Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional formatting for columns, informed by row-level input.

Nic G · 2016-03-07 12:30:43

Hi all I am building a template for which the top row has date columns set up so that all date columns change color based on the date (today/tomorrow/yesterday). The first 2 date columns are, Start Date, End Date, and are not the concern. The remaining date columns, Milestone 1, Milestone 2, etc, are dates which are pulled…

Comments

Nic G ✭

03/09/16 edited 03/09/16

Ah, I was afraid there wouldn't be a formula solve for this.

Thank you so much for all of your help here, Christian!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Trending Posts

Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
Adding formula to help text in Forms
I am looking for a way to display a cell value for the user while they are completing a form; I want to display the current value of an item in inventory that the system thinks we have so the user can adjust it if it is incorrect. For example column = "Gloves", help text would say "We have 6 gloves in stock" and if there…
Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…

Welcome to the Smartsheet Forum Archives

Conditional formatting for columns, informed by row-level input.

Comments

Categories