Forumla error for workday calculations

Data Sources
1

Hi everyone

Was wondering if anyone could help me i am trying to do a formula on a date colum to work out a start date it should be pretty simple but keeps returning formula error have tried AI in softr database and gemini but can’t get to the bottom of it.

This should be the simple formula but everyhting i try it then returns either formula error or json string value error.

Assembly pro date is a lookup field from another table.

WORKDAY({Assembly pro date}, -({IPT + OPT}))

image
image634×299 20.5 KB

any help or ideas would be greatly recieved.

Thanks

2

Try this:

Create a formula field (e.g. {APD} and the only content of the formula is your date field (the lookup) e.g. {assembly pro date}.

In your original formula field use:

WORKDAY({APD}, -({IPT + OPT}))

See how that goes. If there is an error, simplify the formula to WORKDAY({APD}, 1) to check that part works, meaning the right hand side of the formula needs attention.

1 Like
3

thanks i tried that and didn’t work interesting the new APD field does not see itself as a date i.e formating is blanked out.

image
image598×531 26.2 KB

4

That’s right re: formatting (no need for it).

I ran a test as above and had it working. I’m sorry it remains frustrating for you, I now don’t know what else to suggest.

1 Like
5

thanks if i just say equal to assembly pro date that works but as soon as i apply a formula it goes blank