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,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 there,I am trying to attempt to add a formula, that when a certain hotel name is entered in column A, then in column B, depending on that hotel name, it adds the hotel brand automatically. For example:If Hotel Name is Hyatt Centric, then Hotel Bra...
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...
