Hi,
I’m struggling to figure this out. I have two columns (currently Status Columns) column 1 is a list if locations, column 2 is a list of positions worked across all the sites.
What I’d like to do is populate a third column with the pay rate based on the selections made for each site & position. There could be as many a 7 - 10 sites and a fixed set of 5 positions worked. The pay rate can vary at each location and the same person may work multiple positions.
Any Help would be greatly appreciated.
I actually worked this one out.
Payroll rates are set in the Rate Columns for each position.
NO REMOTE OPTION
IF({Venue}=“Venue 1”,“17”,IF({Venue}=“Venue 2”,“27”,IF({Venue}=“Venue 3”,“37”,IF({Venue}=“Venue 4”,“47”,“1”))))
REMOTE OPTION
IF({Position Worked}=“Remote”,“1500”,IF({Position Worked}=“On Site”,“2500”,IF({Venue}=“Venue 1”,“19”,IF({Venue}=“Venue 2”,“29”,IF({Venue}=“Venue 3”,“39”,IF({Venue}=“Venue 4”,“49”,“1”))))))
IF({Position Worked}=“Manager”,{Manager Rate}{Total Weekly Hours},IF({Position Worked}=“Interim Manager”,{Manager Rate}{Total Weekly Hours},IF({Position Worked}=“Asst Manager”,{Asst Manager Rate}{Total Weekly Hours},IF({Position Worked}=“Retail”,{Retail Rate}{Total Weekly Hours},IF({Position Worked}=“Staff Load IN OUT”,{Staff Loading Rate}{Total Weekly Hours},IF({Position Worked}=“Manager Load IN OUT”,{Manager Loading Rate}{Total Weekly Hours},IF({Position Worked}=“Remote”,{Manager Rate},IF({Position Worked}=“On Site”,{Manager Rate},“1”))))))))