This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello! I’m able to make this formula work but I keep getting errors when I try to insert ‘WORKDAY’ into it:
IF({Original Release Date}, DATEADD({Original Release Date}, VALUE(’’ & {Days Needed Before Release}), ‘days’, ‘’))
I am trying to return the ...
Hello!
Hoping I could get some advice on a formula field that accepts my formula but the cells won’t return any data (not even an #error message). Maybe it’s a bug…? Since I’m dealing with multiple formula fields, lookups and a Rollup result that is ...
Hi! I’m at a loss for how to write this formula correctly, even after referencing multiple other topics on here. What I’m working with:
TABLE 1:
“Original Release Date” (formula field calculating from multiple Date fields in Table 1).
TABLE 2:
“Deadl...
I don't think it has. I just tested it: example Maybe you need to tick an extra box or something that I'm not seeing? (My team's interface needs to be prefiltered as part of the interface build as well to filter out records that employees shouldn't b...
Kamille_Parks:
IF(
AND({Original Release Date}, {Days Needed Before Release}),
WORKDAY(DATEADD({Original Release Date}, VALUE({Days Needed Before Release}) + 1, "days"), -1)
)
Clarifying the original formula you suggested as the solution does...
Thanks, Both! Yes @Kamille_Parks is correct that I’m trying to incorporate both DATEADD and WORKDAY in the same formula, and unfortunately it looks like @Justin_Barrett is also correct in that WORKDAY and DATEADD don’t play well together because @Ka...
