addDays

Hi guys,

I was adding a new field 'target acknowledge date' and this field would be dependent on when the record is created (date_created). Target ack date should have a default value of a day added to the date record was created.

I was trying to write a formula using the function addDays, but it somehow is consistently giving me some Boolean error. Does anyone know how this could be resolved?

Parents

0 Shawn Smith 3 months ago

Hi haritha -

It sounds like you're wanting to control the visibility of a field ( target acknowledge date ) based on the result of the formula. Is that correct? If so, the dependent formula must evaluate to either true or false as indicated by the error. Let me know if my understanding here is correct. Also, if possible, provide the exact formula that you are attempting to use. You may just need to add an ifElse to the formula to properly evaluate to true or false.

Thanks,
Shawn
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 haritha raghavan 2 months ago in reply to Shawn Smith

I've figured this out. Turns out I was just over complicating things by trying to use a function instead of just setting the Default value to tomorrow. Hahha This is what happens when you always think of complicated solutions haha
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 haritha raghavan 2 months ago in reply to Shawn Smith

I've figured this out. Turns out I was just over complicating things by trying to use a function instead of just setting the Default value to tomorrow. Hahha This is what happens when you always think of complicated solutions haha
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data