Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of…
Is there a way to hyperlink from one sheet to a specific row in another sheet? I want to be able to click on the link to jump from one sheet row to a specific row in another sheet. Thanks, Stan
How can I use this forumla =TEXT(A3, "ddd") ?? This formula calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu). Every time I try to use this form…
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the l…
Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability. That is somehow not g…
I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets. When the vlookup calculation is entered and I hit the Return key, is it giving…
Is there a way to make predecessors either/or? For example, I have my task on row 3 tied to tasks on rows 1 and 2. But in my project, both tasks 1 & 2 aren't required, they are an either/or kind of ta…
I have two sheets: Change Oorders and Change Order Pricing. IN Change Orders, there is a column called Task1 which is a dropdown menu. The values in the drop down were copied and pasted from Change Or…
I am wondering if it is possible to cell link while in card view? When I try to cell link dates to another sheet it appears I have to go to grid view to make that change. I am submitting a product enh…
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (whic…