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.
Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedbackFranck IF({Date début package} != '', {Date début package},IF({Date début expl 23} != '', {Date début expl 23...
Hello communityi am using a regex extract formulato fill formula fields from a lookup field. the formula works well. But I have 5 formula fields and when the character string separated by commas only has 3 elements, the other two fields refer to the ...
hello community What would be the formula for to extract from the rollup field "participant name (from imported table)" the names entered in this field and to report them individually in the formula fields, do you have an idea of the formula to use t...
Hello, I want to extract from the rollup field "noms des participants" only one of these data for which appear in the fields "Nom Prenon 1" "....2" "....3" "....4" ..... VUE https://airtable.com/shroD4pRoA52pXcg6Thank you for your helpFranck from FRA...
Hello, I want to use the view timeline with the utilization bar. My timeline view allows me to assign tasks to employees. Employees have unavailable days. So I can't assign them spots during this time. The Unavailable Days Utilization Bar only appear...
Hello, thank you for your feedbackI got the solution, here is the formula:IF(AND({A} != '', {B} = ''), DATEADD({A}, {ro}, 'days'), IF(AND({A} = '', {B}! = ''), {B}, IF(AND({A} != '', {B} != ''), {A}, BLANK())))Good day
Good morning and thanks for your help.Here is my expectation.If cell "A" is not empty and cell "B" is empty then cell "C" takes the value of cell "A"and if cell "A" is empty and cell "B" is not empty, then cell "C" takes the value of cell B.If in cel...
Hello and thank you for your feedback, this does not work I am attaching a view of the table Thank you and have a good dayhttps://airtable.com/appYGvpIAdS7m5Hab/shryMIhCEvJUzIFYG
HelloBut here is the problem I encounter on fields that do not contain dataExLookup containsALLIE Pierre, BELUFFI Maeva, MUD AdrienFormula 1 field 1 =ALLIE PierreFormula field 2 = BELUFFI MaevaFormula field 3 = MUD AdrianFormula field 4 = nFormula fi...
HelloBut here is the problem I encounter on fields that do not contain dataExLookup containsALLIE Pierre, BELUFFI Maeva, MUD AdrienFormula 1 field 1 =ALLIE PierreFormula field 2 = BELUFFI MaevaFormula field 3 = MUD AdrianFormula field 4 = nFormula f...
