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…
Is it possible to build a formula that references other cells/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Becaus…
I am trying to determine a way to communicate/graphically represent project progress based on today's date in relation to the start date and projected end date of a project. So if we have a 90 day pro…
I am trying to get a formula to automatically apply a number (vehicles complete column) when a date is filled in from a linked cell in another sheet (completed column), see attached photo for referenc…
So I have this formula for the 'Assigned to' column: =IF([Updated by]1 = "jillian@email.com", "alex@email.com", "mark@email.com") where if someone updates and saves a row, if the email of the person w…