SOLVED
IF Formula (Basic)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
MOlinski
7 - Meteor
‎01-06-2023
10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am working on a workflow and need to update my IF statement below. We just added a "Monthly" pay group, so now it is not just Semi-Monthly and Weekly. I am trying to get it to W = Weekly, S = Semi-Monthly, and M=Monthly. But am having a hard time figuring it out, any assistance would be greatly appreciated.
Solved! Go to Solution.
Labels:
- Labels:
- Expression
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎01-06-2023
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MOlinski
Try this expression:
[Pay Group] + '_'
+
IF Contains([Feq], "W") THEN "Weekly "
ELSEIF Contains([Feq], "M") THEN "Monthly "
ELSE "Semi-Monthly "
ENDIF
binuacs
21 - Polaris
‎01-06-2023
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
