-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
Cells Updated in Original Sheet and not updating in outbound cells
I have a master date sheet that I update dates for projects when they change. These cells that contain dates gets linked to project sheets and should be updated when they are changed. For some reason, the updates are not happening. The cells themselves still say linked. I have tried unlinking them and relinking to no…
-
Merged: Insert Attached Image into Cell
This discussion has been merged.
-
Link to Sheet Summary
I have a Master sheet I am trying to pull in data from other sheets on. One of the other sheets I am linking from has several sheet summaries. I need that summary, which has the sums of several columns) on my Master. Is there a way to link to that summary so it is always updating on my Master?
-
Linking cells into other sheets - Latest update only
Is there a way to link a cell from one sheet to another, but only link over the latest change from changed cell?
-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
Cell Linking to Sheet Summary Field
I like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
-
Send alert when user hasn't accessed sheet in X days
Hey there - I'm trying to set up an alert redirecting users to my sheet to make sure everyone's using it and gently nudging them if they aren't. Here's the logic: IF they a) have permissions to access the sheet AND b) haven't accessed it or changed anything within the last 20 days. THEN Send a message including a link to…
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
Removing Links
I accidently added linkage from one sheet to another. How do I remove those linkages? There are a total of 10 rows and 12 columns that were linked. Thanks!