This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
It would be nice to have a ZIP Code field type so that when a zip code is entered, it would automatically fill in the city and state in a field next to the zip code field.
Here is what I have: 4 columns labeld as follows.
Total Units:Tier: (Single Select with options 1-5)OOM? (Checkbox)Total Pay:
I need a formula to configure total units1.95 for tier 1 and OOM? not checked and total units2.70 for tier 1 and OOM? checke...
Here is what I want:
I want a formula to multiply the Total Units by 1.95 if OOM? is not checked. And if OOM? is checked, I want Total Units to be multiplied by 2.70.
Let me know if you need anymore info from me. Thanks in advance!!
I am looking for an hours worked field. I have two date/time fields. One is labeled “Time Punch In:” and the other is labeled “Time Punch Out:” in the next field that is labeled “Total Time:” I want it to put the hours worked into it. I can get it to...
Like you, I require the use of City/State on one of my tables. However, I do it a little differently with a formula. I created a formula, so that when the zip code is entered into a number field, the city and state automatically populate. I really li...
I am currently using the following formula, but per the formula formatting section, my function is not fully configured, and I can not change the format to a currency. What do I need to add or take away?
IF({Tier:}=1, IF({OOM?}=1, {Total Units:}*2.70...