Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of m…
Hi, I am linking date columns from a master sheet to another sheet. When linked it seems to change the format of the date. For example if the date in the original sheet is 12/08/19 (12th August 2019) …
Hi, We have sheets that have linked cells between them. I want to set up automated alerts if someone changes any information on that row, but would settle for changing specifically the dates (which ar…
My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, …
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the d…
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…