Creating a collated punch list of unfinished tasks Hello! I've got a project tracking spreadsheet going for a mid sized team project and as we near com…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

How can I make my AppScript to copyrows dependent on a checkbox and force cell L data to cell B I have two script options in my sample file to copy down data from rows, but I need to expand upon t…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Script not working in shared files I have a script that has been working as far as I can tell with one exception. The scipt is for chan…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

page set up option missing page set up option missing

0 Updates 1 Recommended Answer 5 Replies 0 Upvotes

count number of words in a cell Hi , I am trying to find a function to count the number of words in a text cell. I have tried differ…

0 Updates 1 Recommended Answer 5 Replies 0 Upvotes

Annual Budget Template: Adding additional income I would like to add 1 more section to the income sheet so that is also reflects on the summary sheet…

0 Updates 1 Reply

Sum cell values of data range | Total in one cell if dates are the same Hi All, I have a sheet with dates from C22:C59. I have values From F22:I59. However, some cells are …

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Trying to drop 2 lowest scores out of 10 when the total of all cells is not a grouped set. This is my formula to get the total of 10 columns, but I need the lowest two scores dropped and for …

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

I am pulling my hair out, lol. My Vlookup that has somehow just totally stopped working For some reason my vlookup equation is not working anymore! It is not recognizing a date column as a…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

I need help finding data in separate rows and columns in a filter search in google sheets I need help setting up table in such a way that I can use a filter search to find data I need to. I …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Activity Dashboard Missing from Sheets Hi, I don't have the option for Activity Dashboard on sheets. I am an administrator with Google Work…

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

I want to replace a script with a formula. https://docs.google.com/spreadsheets/d/1SSJcDGRZM_oZZEylmiU_EQFtQrqzFMHyab3H9YAw5rk/edit?gid=9525952…

0 Updates 0 Recommended Answers 9 Replies 0 Upvotes

There’s something wrong with Google Sheets, and the results don’t make sense. The range I10:I72 represents batch numbers, N10:N72 represents items, and O10:O72 represents quantit…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Google Sheets: cannot choose Smart chips as Calendar events Hi everyone, When I'm choosing Smartchips in the table, I cannot select Calendar events to use. I've…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

my yesterday data is not saved my data is deleted without my concern

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Conditional Formatting assistance I'm trying to figure out how I can use conditional formatting to assign colors to each team member. …

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

I need to insert more then one column I need to insert many columns and just one is taking forever.

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

Named Ranges I am trying to use Named Ranges (cells) in menu formulas. Sheet 1 contains my product list. Column E…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Calculate cost based on date I need a formula to calculate the cost if there is a date in column I and how many days the cancel d…

0 Updates 0 Recommended Answers 8 Replies 0 Upvotes

LEN Function Not Working Hello, I am unable to get the LEN function to work in Sheets. When I convert the file to excel, the …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes