Penny_Bell - profile

Penny_Bell · Oct 17, 2023

Hello, I am having issues with adding additional advertising week options to the formula below. This formula works well:IF(AND({Advertising Plan}, {Live Date}),SWITCH( {Advertising Plan},"4 weeks", DATEADD({Live Date}, 27, 'days'),"52 weeks", DATEADD...

Penny_Bell · Aug 22, 2022

Why are all my DATETIME_DIFF formulas coming up as a negative number? My formula is: DATETIME_DIFF({Birthday}, TODAY(), ‘years’) and I am getting for example -29 instead of 29.

Penny_Bell · Oct 23, 2023

Yes, I need a switch on every option. If there is a better way to do it please let me know. Basically, the Advertising Plan needs to be one day less than the specific number of weeks. So 2 weeks is actually 14 days, etc etc

Penny_Bell · Dec 18, 2022

Is there a cost associated with a user on a pro account but only having access to an interface?

Penny_Bell · Aug 22, 2022

I figured it out it didn’t like the curly braces. Used: DATETIME_DIFF(TODAY(), Birthday, ‘years’) Thank you!

Penny_Bell · Aug 22, 2022

Strange - they have worked for other formulas just fine.

Penny_Bell · Aug 22, 2022

Ok, so it worked with this formula putting the date first: DATETIME_DIFF({Check-out}, {Check-in}, ‘days’). But for this formula: DATETIME_DIFF(TODAY(),{Birthday},‘years’) and DATETIME_DIFF(TODAY(), {Birthday}, ‘years’) I got the attached error messag...

User Statistics

User Activity

Need Help with IF and Switch Formula

DATETIME_DIFF Formulas Help Needed! Negative Numbers

Re: Need Help with IF and Switch Formula

Re: Change Base collaborator to Interface-only access

Re: DATETIME_DIFF Formulas Help Needed! Negative Numbers

Re: DATETIME_DIFF Formulas Help Needed! Negative Numbers

Re: DATETIME_DIFF Formulas Help Needed! Negative Numbers