nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Formula to fill in blank cells if condition is met and leaving alone if condition not met

nickrosen28

Hi everyone,

I am attempting to fill in blank cells if these are met: {category] is "Other" and [Task] is blank

I want to fill the blank with the word "Other"

If those arent met I want to leave the cell alone.

Some tasks are blank and some say "Null" i want both instances to say "Other" if the conditions are met.

How would I go about doing this?

Thanks!

Expression

Accepted answers

binu_acs

@nickrosen28 If your formula has a hard-coded value you will not get the desired result

Condition_check_190623.yxmd

All comments

hellyars

@nickrosen28

Try this...

if isnull([Task]) then "Other"

elseif isempty([Task]) then "Other"

else null()

endif

hellyars

@nickrosen28

Sorry.. you can modify the above to

if [Category]="Other" and isnull([Task]) then "Other"

elseif [Category]="Other" and isempty([Task]) then "Other"

else null()

endif

hellyars

@nickrosen28

I fixed a few typos in the formulas above.

The formula works (don't mind the workflow as I was playing around) -- the Formula tool should be sufficient.

hlee36

@nickrosen28

You can use the formula tool and but make sure to use a temporary column.

Also, you can use the function "IsEmpty", which recognizes both blank with "" and null value. And then, you can change the column name.

Edit:

I put space in the bottom three rows and trimmed that to put blank value.

Check all the rows are now "Other"

isempty.yxmd

nickrosen28

Thanks for the speedy reply!

It works with 1 issue, all of the other "task" cells are Null for the ones that use to have data in them.

For example for a row with Category "Forecast" used to have task "Update Model"

Now it says "Forecast "and task "null".

Just need a small edit where it will leave the columns alone rather than turning them null if they dont meet the criteria in the If then portion of the statement.

Thanks again, trying to figure it out but wont work.

binu_acs

@nickrosen28 If your formula has a hard-coded value you will not get the desired result

Condition_check_190623.yxmd

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15906

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703