Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 14, 2023 04:45 AM - edited Apr 14, 2023 10:05 AM
Hi there,
I'm experiencing a strange situation with a simple formula. Here's what i'm using:
Solved! Go to Solution.
Apr 14, 2023 10:56 AM
Try like this
ù
You have a hidden "calculation field with this formula
And then this formula in the Working days field
Apr 20, 2023 07:59 AM
mmm you should follow the instructions above
You have a hidden "calculation field with this formula
Apr 14, 2023 09:41 AM
Hi, you could try using this formula
Apr 14, 2023 09:55 AM
Hi Rodolfo, thanks for your reply,
Unfortunately, that didn't do the job. The error i'm getting is not that i get a positive number that should be negative. The thing is, calculating workdays between today (Friday) and yesterday, i'm getting 3, instead of 1.
Thanks!
Apr 14, 2023 10:06 AM
Are you using this formula in your formula field?
If I use this formula with my Date field I get this
Apr 14, 2023 10:56 AM
Try like this
ù
You have a hidden "calculation field with this formula
And then this formula in the Working days field
Apr 17, 2023 02:03 AM
Hi there!
It's working! Thanks! I don't know how i set it up before, but now it seems to be working perfectly!
Thanks a lot!
Apr 20, 2023 07:41 AM
Hi there,
This formula doesn't seem to be working when trying to get the number of working days from today to yesterday. It works apparently well in other cases.
Being today 20/04/2023, I get -3 instead of -1:
Here's the formula, just in case:
IF( DATETIME_DIFF({Fecha Experiencia}, TODAY(), 'days') >= 0, WORKDAY_DIFF(TODAY(), {Fecha Experiencia})-1, (WORKDAY_DIFF({Fecha Experiencia}, TODAY())-1)*-1)
Any clue on why is this happening? Thanks in advance,
Javier
Apr 20, 2023 07:59 AM
mmm you should follow the instructions above
You have a hidden "calculation field with this formula
Apr 26, 2023 02:27 AM
Thanks! It worked!!