filling in blank cells with texts

Question

Hi All - and it seems quick but I'm stuck

I want to fill in the following texts when 2 criteria's are meet - so if the column Hourly Salaried is blank and either FT or PT REgular + FT & PT Temp then Regualr in Ass.Cat Map

See table below

If [Hourly Salaried ]= blank and [Assignment Category] = "Full-time regular" & "Part-time regular"  then  "Regular" in the Assignment category If [Hourly Salaried ]= blank and [Assignment Category] = "Full-time temporary" & "Part-time temporary"  then  "Regular" in the Assignment category

Assignment StatusAssignment CategoryHourly SalariedAssignment Category Mapping       Active - With PayFull-time regularSalaryRegular       Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time regularSalaryRegular       Active - With PayFull-time regular         Active - With PayPart-time temporaryHourlyTemporary       Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time regular         Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time regularSalaryRegular       Active - With PayFull-time regular         Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time temporaryHourlyTemporary       Active - With PayFull-time regular                                           If [Hourly Salaried ]= blank and [Assignment Category] = "Full-time regular" & "Part-time regular"  then  "Regular" in the Assignment category  If [Hourly Salaried ]= blank and [Assignment Category] = "Full-time temporary" & "Part-time temporary"  then  "Regular" in the Assignment category

atcodedog05 · Answer

Hi @Arkouda

Here is a formula for the Calculation

IF isnull([Hourly Salaried]) AND ([Assignment Category] in ('Full-time regular', 'Part-time regular')) THEN 'Regular'
ELSEIF isnull([Hourly Salaried]) AND ([Assignment Category] in ('Full-time temporary', 'Part-time temporary')) THEN 'Regular'
ELSE [Assignment Category Mapping]
ENDIF

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Formula.yxmd

grazitti_sapna · Answer

Hi @Arkouda , try this.

Thanks.

filling in blank cells with texts-GS.yxmd

lmorrell · Answer

Hi @Arkouda

Packaged workflow is attached.

Thanks for attaching the excel document, by looking at the cell types on Sheet 2 - I can see that the blank cells are null which is important for the end calculation.

Based on the logic provided, a formula that writes to the "Assignment Category Mapping" column is as below.

if isnull([Hourly Salaried]) AND ([Assignment Category] in ('Full-time regular', 'Part-time regular')) then 'Regular'
elseif isnull([Hourly Salaried]) AND ([Assignment Category] in ('Full-time temporary', 'Part-time temporary')) then 'Regular'
else [Assignment Category Mapping]
endif

Hope this helps!

filling in blank cells with texts.yxzp