-
Add 1 Month to Date for Multiple Years
Hello I am trying to build a formula that will add one month to each cell as shown in the sheet below. When a new year starts however I get the error indicated below. Any thoughts on how to fix this are appreciated!
-
Send Form for Completion to Individuals with Pre-Populated Fields taken from Data in the Sheet
I have a sheet called 'Farmer Access Survey' which will contain the current data we hold on record for 130 farmers. I have created a form, which I want to send to each farmer to confirm the current data we hold, and collect additional information from them. Can I send a link to the Form to each individual in an Outlook…
-
Auto populate a cell with data from the cell above
OK, so I have been up for two days straight between work and being sick (just to set the mindset here). This seems so simple and yet in my exhausted state, I cannot get this to work. Column Name (Machine Number) Column Name (BOM Style). I have two forms to capture the data. Form One captures Machine Number and BOM Style.…
-
Is there a way to lock the column index number in VLOOKUP across sheets?
I'm performing a VLOOKUP across sheets, which works great until I add a column to the source sheet, thereby shifting the column index number. The formula retains the original column index number, so the output ends up being wrong.
-
Populated number via Form is updated wrong in the sheet
We are using a form to update invoice data and value, in some cases the value entered into the form is loaded with the wrong value into the sheet. e.g. entering a value of 10,000 sometime updated in the sheet as 9,997. This has been noticed on round numbers such as 150,000 is loaded into the sheet as 149,999. Does anyone…
-
Can you skip a row and still use Column formulas?
Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a…
-
Count the dates in the current month
I have a list of dates in a column on a sheet. I am looking for a formula that would count only the dates in the current month and year, e.g., November for now and next month it should show the count for December 2022. It would be greatly appreciated if someone could help me out here.
-
Count by date and person
I have successfully used the formula below to return a count of submitted issues on a log that have been resolved within the past week. I need to now take this amount and record the count by staff member who resolved the issue. On the source sheet I have a column where the individual is listed "First name Last name".…
-
Can you use sheet/row comments in formulas or otherwise?
Is it possible to write formulas using an IF statement based on if there is a comment @row or not? A quick follow-up. I understand how conditional logic in a webform may help for this, but if you are sending an update request automation or an approval request automation, is there any way to REQUIRE that a comment be made…
-
Collecting valued with IF Dependencies
I'm stumped in trying to average the values in a column ( CMO Dispo) that meets the criteria of CMO column - "Agilent" DOM column - 2022 year Current non-working formula: =AVG(COLLECT([CMO Dispo (Business Days)]:[CMO Dispo (Business Days)], MFG:MFG, ="Agilent", DOM:DOM, =YEAR(2022, 1, 1))) I'm pretty sure its not working…
