IF Formula Assistance

Question

Hi!I'm trying to create IF statements based on if a field is = to X, then based on the selection, I want to populate a specific target date.Example, if "0 - (Optional) - Fast Track Modifications" selected from the Credentialing Standardization Tasks field, then add 3 days to the Targ Date.This is what I have so far on the Targ Date field:If([Credentialing Standardization Tasks] = "0 - (Optional) - Fast Track Modifications", [Start Date]+Days(3))1. Is this possible?2. If it is, am I able to have 16 other IF statements for the Targ Date field? Each of these tasks have different target dates.* I needed to create a Targ Date field (Formula - URL) as the Target Date field was a Date field and is being used in other areas and I'm afraid it unintentionally affect what it's being used for in other areas.* I have a dynamic form rule to populate what's in the Targ Date field, in the Target Date field since I couldn't build (the above) on the Target Date.Thank you!------------------------------Clarice Dennison------------------------------

MarkShnierYou · Answer

If you want to make a formula field to calculate a Calculated date field, then you can do a single IF and list the tests vertically for readability.
If(
[Credentialing Standardization Tasks] = "0 - (Optional) - Fast Track Modifications", [Start Date]+Days(3),
[Credentialing Standardization Tasks] = "1 - xxxxxxxxxx", [Start Date]+Days(4),
[Credentialing Standardization Tasks] = "0 - yyyyyyyy", [Start Date]+Days(3)
)

IF all of your of your tests are against the same field, then you can also use a Case Function

Case([Credentialing Standardization Tasks],
"0 - (Optional) - Fast Track Modifications", [Start Date]+Days(3),
"1 - xxxxxxxxxx", [Start Date]+Days(4),
"2 - yyyyyyyy", [Start Date]+Days(3)
)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community