Hello community!I have a column with 3 simple choices "number of trucks" and I wants to convert these choices into figures in a "quantity" column. IF({number of trucks} = "3 trucks of more", "0", )IF({number of trucks} = "1 truck (24 tons)", "24",)IF...
Hello community!I am looking to display the amount of an hour of additional service to be applied to a price depending on the type of service (A, B, C or D).This number of hours can be 0, 1 or 2.I have already created a column that automatically disp...
Hello, I am a pro writer for companies and I am looking to generate quotes automatically.Depending on type of report (4 types) selected by the customer AND the time of writing (full day or half day) the price will vary.I want to convert this example ...
Hello,I'm totally new in the formula game, I created mine by putting pieces of tutorials together and using answers obtained here (by the way, thanks to the community!)That's the deal :When my cell x show 1h, I need to show 0When my cell x show 2h, I...
Hello,I configured my date format to European on Airtable, however, when I send this data to Integromat and making a Google Sheet template, it reformats the date in US.Date on Airtable (03/12/2022) :Date format received by Integromat (2022-12-05, yes...
I found a solution few days ago with :DATETIME_FORMAT(
SET_TIMEZONE({AutoDateOfTheDayField}, 'Europe/Paris'),
'D/M/YYYY'
)Thanks a lot @Justin_Barrett & @kuovonne !
Hello @Andrey_Kovalev,Thanks for your help.I think I made a mistake in my message during the translation of fields names.This is what my formula looks like at the moment (with no errors this time):SWITCH( {Type of package},
"half day", SWITCH( {Type ...
