Sign in to join the conversation:
I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.
You cannot reference hierarchies directly with cross-sheet references. You would need to calculate those values on the source sheet, then pull them to your target sheet.
How can I set up instructions from an earlier coloumn, if someone has selected Bonus A this means that a payment is due 6 months after the start date so need to show this date in the column
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
