Example: I have a workspace that have 300 folders for 300 different project names. Each project name have subfolders in which one is called sheets. The sheets have 4 sheets in which one is called cost…
I'm trying to get the distinct list of contcats (email address) from another sheet. I'm using =DISTINCT(COLLECT({Email Address}, <>"")). The email address is the entire column - not a cell range.
I’m in sheet name “Summary” and trying to get total “Cost” from Sheet name “Expenses” where “Charge Date” in sheet “Expenses” between 10/1/2023 and 12/31/2023 - I’m getting Unparseable error. The form…