Timesheet Overtime and Regular time Enum Initial value/app formula in another colum

[Josh_Klassen]

What I want to happen is something like:

“Enum column = Regular time Rate then use [Regular Time Rate]X[Number Of hours] or if Enum column = Over Time Rate then use [Over Time Rate]X[Number Of hours]”

for some reason this forum isn’t showing the * symbol in the expression above so it has been replaced with X

Some background information:

I have two tables,

One is Position
The other is Timesheet

The position table stores what the Regular Time rate is in one column and the overtime rate is in another column.

I then have a column in the timesheet table that has Total wages.

Enum column has two options Regular Time or Over Time and based off of what the user selects for example the regular time rate would be 30 and the overtime rate would be 1.5 times the regular time rate being 45.00. I want the app to automatically calculate what the labour total would be based on what the user selects from the enum column

Right now It will automatically calculate with this formula for the regular time rate

[Regular Time Rate]*[Number Of Hours]

[Steve]

help.appsheet.com

IF()

Either/or conditional evaluation

[1minManager]

IF(
[EnumColumn]=“Regular Time”,
[Regular Time Rate][Number Of hours],
[OverTime Rate][Number Of hours]
)

Assumes [Regular Time Rate] and [OverTime Rate] are columns which are numbers, decimals or price type

Simon@1minManager.com

[Steve · Accepted solution]

To clarify @1minManager’s snippet, since some was lost to formatting:

IF(
  [EnumColumn]=“Regular Time”,
  [Regular Time Rate] * [Number Of hours],
  [OverTime Rate] * [Number Of hours]
)

[1minManager]

@Steve how do I stop it doing that?

[Steve]

markdownguide.org

Cheat Sheet | Markdown Guide

A quick reference to the Markdown syntax.