Formulating
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there, team.
I need your help in formulating.
I've got two columns, a and b. If a=fail, then the b column should not be empty.
- Labels:
- Best Practices
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sunilmnv this is a little vague. Are you saying where [a] = fail and [b] is empty, you want to filter those out? Or you want to populate [b] with a certain value? What does your input look like and what do you want the outcome to be? Would be great if you could provide an example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Sunilmnv,
Does this give the logic your looking for?
The formula passes the value for B if A = "fail".
Any questions or issues please ask :)
HTH!
Ira
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Sunilmnv, may I ask for further details on the condition like what could be other text in the column A aside from 'fail' and if column B should not be empty, what data should be written in there.
Anyhow, I wrote a simple workflow that satisfy basic condition. You may change the formula as you desire.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It’s a free text any thing can be written but should not be blank
