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 al…
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?
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…
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…
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!
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets…
I have 3 sheet across 3 different departments. first being the master sheet where the majority of information is collected. as selections are made in certain columns the row is copied to other sheets.…
Looking to create a count of the number of times a name appears. in another sheets column. I keep getting a false result. =IF(CONTAINS({EE Schedule Range 3}, {EE Schedule Range 2}), "Yes", "No") Range…
Ok this one seems to be a little more advanced of a question, once a row is copied to another sheet is there a way to link the the copied row to original row so that whatever changes are made to the c…
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that…
