I'm making a saved search for all quotes that have...
# general
t
I'm making a saved search for all quotes that have a custom checkbox checked. Does anyone know how I can show the date when the checkbox was checked (true) in the results? Sounds so simple, but I'm a little lost.
a
use the system notes field = custom check box where old value is F and new value is T
t
Hmm. I suppose i can write a formula for this. Okay, thank you
r
Don't forgot to add the date in the results.
a
@ted_p formula (numeric) | case when systemnotes.field = {customcheckbox} and systemnotes.newvalue = T then 1 else 0 end.
t
@Angel Thanks! I was getting some errors with formulas yesterday, so I found a different way. I made the Criteria looking for System Notes : Field is my custom field, and also System Notes : New Value is T Then, I made results show System Notes: Date
💯 1