I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY...
Hello! I am looking for an advanced questionnaire, either in Forms for Airtable or an integration. I would need it to be in sections (each section having a little header with directions), and an if-then conditional type of response, where if they ans...
Hello,I need help with my formula.If <total amount paid> is not blank, then the cell becomes <ACT Planner>. However if <total amount paid> is blank, then cell becomes <EST Planner>.I got this far, but can't get the 2nd part to work:IF({Total Amount P...
I am working on an invoice in the Page Designer extension and having trouble adding multiple line items. Company A has multiple line items in by Base. The unique identifier is the Company Name "Company A". In Quarter 1, 2023, Company A used 3 differe...
I am struggling here! I thought I was getting better - but I need help. Thank you in advance!My column is "Sourcing Manager" and I am trying to create another column with a formula to add their email automatically.If the Sourcing Manager is "Monique"...
Hi! I think I am missing something - still getting an error:SWITCH(<Tab in 1>{Hotel Portfolio},<Tab in 2 all below> "25 Hours", "Accor","Adagio", "Accor","Angsana", "Accor","Art Series", "Accor","Banyan Tree", "Accor","Delano", "Accor","Fairmont", "A...
