+5I am working on a project for a service company. I have a table with clients and then a table of projects that are linked back to the client. Clients are assigned a rate based on different factors. The rate is carried through to any of the projects they are linked to via lookup field. However, I would like to override the lookup field should we have a promotional rate or a specific project needs to be billed at a different hourly rate.
Any suggestions?
Best answer by TheTimeSavingCo
Create a number field where you can key in the override, and then create a formula field that'll use that value if it exists and use the lookup if it doesn't:
IF(
{Rate override},
{Rate override},
{Rate (from Clients)}
)
+31Create a number field where you can key in the override, and then create a formula field that'll use that value if it exists and use the lookup if it doesn't:
IF(
{Rate override},
{Rate override},
{Rate (from Clients)}
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.