-
Moving rows
Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?
-
Using formula to copy row to new sheet as a child row
We have created web forms to retrieve new client information and new project information. Both forms contain the Primary Column "Client Name". I know we can link cells from one sheet to another. But what I'd like to know is if we can set a formula (or link a sheet) so that when a new form is submitted (and it is added to…
-
Can I eliminate everything from a cell except for the end?
I would like to create a new column that will essentially copy over information from a different column but will only take the last few digits. For example, the first column will say "John's Business 290583958". The last digits would be the Sheet ID of "John's Business". In the second column, I would copy over the…
-
Help with Children Function
I am using =COUNTIF(CHILDREN(), "") + " Missing Data" which works fine. I am trying to modify this to only show a value if there is missing data otherwise be blank. I have tried numerous iterations of the IF command and always end up with "Unparsable". Any suggestions? Thanks
-
conditional on children function
I am using this =COUNTIF(CHILDREN(), "Y") + " Bidding" which returns the number of contractors bidding. I would like to change the font color depending on a range of values that the "count" returns. I can get the zero value easy enough but I wiuld rather not enter a conditional statement for every possible numerical value…
-
Convert date format to mmm-yy
Does anyone know how to convert a date in dd/mm/yy format to a mmm-yy format with a formula like =TEXT([Start Date],"mmm-yy")? Thanks.
-
SUMIF invoice totals from the past 6 months
Hi- I have a sheet that I input invoice amounts into for multiple outside contractors. I have the name of each contractor as a parent row and their invoices as the children rows. The columns are date, invoice number, billable items, amount and code name. I want to create a formula above all parent rows that would SUMIF the…
-
Automatically Sum rows that have the same value in a specific column.
I would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in…
-
Sumif for date ranges
This did not seem to be covered and I'm hoping to find a formula without adding extra columns to my sheet. Curently I have a secondary column separately maintained which lists months and I Sumif by this secondary "month" column. I would like to Sumif based on date ranges. Not simply from today() but actual Date A - Date B…
-
Merging the text of 2 cells into 1.
Hello, is there a way to merge the text of 2 different cells into 1 please? I have tried several versions of this but I get different error messages. =(([cell]1) &” “&([cell]2) Thankyou.