filling in blank cells with texts

[Arkouda]

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 Status	Assignment Category	Hourly Salaried	Assignment Category Mapping
Active - With Pay	Full-time regular	Salary	Regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time regular	Salary	Regular
Active - With Pay	Full-time regular
Active - With Pay	Part-time temporary	Hourly	Temporary
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time regular	Salary	Regular
Active - With Pay	Full-time regular
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-time temporary	Hourly	Temporary
Active - With Pay	Full-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

[Arkouda]

with attachment 

[lmorrell]

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!

[grazitti_sapna]

Hi @Arkouda , try this.

Thanks.

[atcodedog05]

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 😀👍