Smyth_County - profile

Smyth_County · Mar 19, 2024

I'm trying to write a formula to remove the "➟" if the preceeding field is empty.Current Formula:Origin& " ➟ " &{Destination}&" ➟ "&{Backhaul From}& " ➟ "&{Backhaul To\\Return}& " ➟ " &Origin &" - LANE #" & {LANE#} Here is the output of the above fo...

Smyth_County · Jun 15, 2022

Not sure this is possible but I can’t seem to get this to work when I add the second part. I have a formula that works this way 'If Base Rate = 0 and IF UM= “Pounds” then Weight / 2000 * Price, IF Base =0 and IF UM= “Kilograms” then Weight / 2200 * ...

Smyth_County · Jun 10, 2022

I have a table that each record has an effective date that contains data that changes weekly. Is it possible somehow to have the data tied to those records to be view as historical data? My first thought would to be copy the table and date it, but ...

Smyth_County · May 26, 2022

I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number. What I’m trying to accomplish: Average Weight = 10000, Base Rate...

Smyth_County · May 23, 2022

I can’t seem to figure this out. Here is what I’m trying to accomplish. When A Record Matches a Conditon In Table 1, then Update Record in Table 1 (Field 1) with data from Table 2 (Field 1). Is this possible using the automations? Esssentially wha...

Smyth_County · Mar 20, 2024

Thanks this worked!

Smyth_County · Mar 20, 2024

Thanks this worked!

Smyth_County · May 26, 2022

Thank you that fixed it!

Smyth_County · May 23, 2022

I understand what you are referring to, but this logic seemed to work better for my project. I did figure it out, I had to create two actions, one to Find records to locate the field in table 2 and then Update records to place the data in the correc...

Smyth_County · May 23, 2022

I’m not sure how to make that Link Record field work with the drop down? The Policy in table 2 is a numerical value from a formula that will used to compute data on Table 1

User Statistics

User Activity

IF AND Remove Text

Nested Formula Issues

Best Practice To See Historical Data

Trying To Get Formula to Add Percentage

Using Automation to Pull Field From Another Table

Re: IF AND Remove Text

Re: IF AND Remove Text

Re: Trying To Get Formula to Add Percentage

Re: Using Automation to Pull Field From Another Table

Re: Using Automation to Pull Field From Another Table