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…
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
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…
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.
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…
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…
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…
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.
It would be great to have the hyperlink feature not just be limited to web sites. If I could put a link to a file located on my network, I could then send a notification or send a row and the email that would be delivered would allow me to click on that link to open the file or network location locally. Ex: A cell has a…
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…