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 on children function
I am using this =COUNTIF(CHILDREN(), "Y") + " Bidding" which returns the number of contractors bidding. I would like to change the font color depending on a range of values that the "count" returns. I can get the zero value easy enough but I wiuld rather not enter a conditional statement for every possible numerical value but rather a "> X" or ">X < Y" and such.