-
Date formula previous month for a new year
I'm still getting my head around date formulas, I have one to tell me the start date of the previous month: =IFERROR(DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) - 1, 1), DATE(YEAR([Date Column]@row) + 1, 1, 1)) This worked fine until we changed to a new year, what have I done wrong with this formula?
-
I would like to compare week number with column name
I have a column for each work week of the year (1 to 53). I would like to append the value of HC Plan on its respective column, based on Start Week and End Week. For example, if a project starts on week 1 and end on week 2, I need to append a Head Count of 5 to the columns of Work Week 1 and 2, to keep track of HC needed…
-
Missing automations, formulas and column setup when importing data from excel
I need your help on a doubt I do have using the templates in Smartsheet. I have several projects that are using the same template and I saved that template with some formulas and automations (Example: record a date when someone changes a date...). Then if I want to import data from excel into that template, the…
-
How to use COUNTIFS Month/Year with cell displaying Month/Year
A report is initially downloaded into Excel and a marco places the report date into each cell in the Report Date column. The entire report is then copied into Smartsheet. I will refer to it as the report. A "Metrics" sheet will be counting various categories from the report for each month in a biennium. In one of the first…
-
Mutltiple IF(AND.... help with time stamps
Re-posting from "discussions" as I think it was in the wrong place. I am trying to separate entries for day shift (8am-4pm), afternoon shift (4pm-midnight) and night shift (midnight -8am). I can countif for the date entries. But because the time from an automated report is "funky" I can't get it to work. So I added a…
-
Using AVGW(COLLECT and still missing the mark
We would like to caluclate a weighted average for the total number of projects our Project Leads manage. I tried using AVGW(COLLECT to total the weights assigned to their projects with the formula below, but received an Incorrect Argument error. (The IMs column is calculating their total projects) The way we are assigning…
-
Count Formula
I am working on a sheet summary for a dashboard. I have a column "Contract Status with a drop down down menu of choices, (Closed, Under Contract, Pursuing) and another column "States" that denotes which state the contract is being negotiated in. I want to count if the contract status is Closed and is in the state of…
-
Send a notification when all rows in a sheet are marked as complete
I'm trying to figure out a way for a notification to be triggered when all rows in a sheet are marked as complete. I've tried to create a new column that would have the first cell with a formula that will Enter a 1 if the count of the Status column with Blue equals the count of items in the primary column. So something…
-
#Incorrect Argument Set with =COUNTIFS
Hi all, This is baffling me. I have a very simple formula... =COUNTIFS({Epic Name}, [Primary Column]@row, {Current Sprint}, 1). I am using this for a metrics sheet to be used for dashboard reporting. This is working as expected in it's own sheet but when I use the exact same formula in a bigger/consolidated metric sheet,…
-
How do I place a date in a column when approved is marked in another column
I would like to use the IF function IF(RMReview@row=Approved or Rejected,) The formula is unparseable and I agree. I just don't know what to place in the formula to get a date. Appreciate the help!
