View Single Post
Old 05-06-2013, 03:46 PM   #73
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,449
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by rifka View Post
I'm not sure what to do with what you gave me. The formula I gave you went into the template field for a new column.

Basically what I want is:
if the NUMBER field is blank then "NA"
if the NUMBER field is greater than 0 then "calendar"
if the NUMBER field is less than 0 then "star"

Thanks
what I gave you is a template in general program mode. Just copy and paste it into the template box. If you have already created the new column then click on any cell in the column and press F2 to open the template editor, then paste it there.
chaley is offline   Reply With Quote