Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!
In the MP IMU% field I have this formula:
IF({MP ICOGS},SUM({MP IGP} / {MP ICOGS}))
My question is how do I change my formula to return a value in the MP IMU% field that is not a negative percentage? The true answer is 281.34% - I’m beyond stumped?...
I have expense fields set to ‘Allow Negative Numbers’. It would be really helpful to just enter 5.24 and have that field make it a negative number. I have a ton of fields I need to manually enter the currency for and trying to remember to add the m...
Is this even possible? I’ve watched a ton of automation tutorials and can’t find an answer.
From the Transaction Type: Order >Item ID field I would like to add this ID # to the Transaction Type: Shipping label >Item ID
And pretty much do the same th...
I clicked the link but the video only demonstrates adding one record. I am a visual learner is there a video that demonstrates a user filling it out and creating multiple records in one form? Maybe I have misunderstood - I need a single form that c...
Many thanks to @W_Vann_Hall and his demonstration base for Pretty Print - for an answer!DATETIME_FORMAT({Date of Trip}, 'YYYY-MM-DD')&"\nTrip Total: "& IF(LEFT({Sourcing Trip Total}&'',1,1)='-','-','')&'$'&IF(ABS(VALUE({Sourcing Trip Total}&''))>=100...
ScottWorld:
miniExtensions Form to Edit and Create Airtable Records
It’s a shame Airtable wants me to spend $39 a month with another company so I can use a form to update existing data in my free Airtable. I love Airtable but their inability ...
@augmented Thank you!
IF({MP ICOGS}, ABS({MP IGP}/{MP ICOGS}))
This worked!
COGS are actually expenses therefore they are entered as a negative number. All the income fields are entered as positive currency. Excel makes this easy but not so much ...
