Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to…
Hello I need help with creating if and then statement to perform the following. If Recruited From = Referral And Store Start / Transfer Date = Date Then Store Start / Transfer Date +90 days Here's the…
Hi, I'm struggling to combine a SUM and a COUNT together (keeps returning an error). =SUM([CELL 1]22:[CELL 4]22) / COUNTIF([CELL 1]22:[CELL 4]22, <>"N/A") This returns a #DIVIDE BY ZERO. CELL 1 to CEL…
I need to do the combination of formatting with and alert, but seem to have hit a wall. If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st de…
I noticed when I create a drop down list for contacts and select "Restrict to list values only" it works great in the main sheet, but when I view the same column in a report it is not restricted to li…
I would like to summarize the cost of each month in the current year. columns for each month and year. I do not get the formula: =SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start140…
Hello Everyone, I am looking for a formula that will add today's date if certain criteria has been met. If "Approved" or "Denied" has been entered into the Status column I would like today's date to a…
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works …
I have an existing sheet with formulas to compute "netdays" left for a task, the task and variables live on the same row. That sheet has a form which allows for a user to add to the sheet a new task a…
I would like to move data from one column to another. Is there a formula that can do that? I may append to existing data or replace it depending on options. If there's no formula, how can this be done…