-
Formula to Create Unique ID on Specific Rows
Hi Everyone, I am trying to create a unique ID but only on specific rows, so the auto-number column type is not suitable. I would like the ID to be sequential. I started by generating a number, 1, where Course and Action Due Date are blank. I have successfully done this by using the formula: =IF(AND(ISBLANK(Course491),…
-
COUNTIFS to include cells with text
I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. I've come up with the formula below, but I get an Incorrect Argument error: =COUNTIFS({Review Month}, =1, ISTEXT({Critical 1})) Where am I wrong here?
-
From X to End of column
My sheets have a "header" that serves as a navigation and also serves for the metrics. My problem is that I would like to have the range of a function encompass the entire column (open-end) but i want to be excluding the aforementioned header rows. I tried thing such as [Column Name]21:[Column Name] in an attempt to splice…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Complex Formula for RYG Automation
I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date] <100, "Green" IF [Proposed Product Launch Date]…
-
SUMIFS trouble
I feel like I'm almost there with this, but just can't figure it out. I'm trying to determine a Sales Rate (money/hours) per Estimator, per month (date range). My column headings are: Ops Start Date, Estimator, Scope Hr, and Contract Amount. I think the problem is using a date range within a SUMIFS formula. I know its…
-
SUMIFS Multiple Criteria
I'm beating myself up. Im trying to calculate the sum of tasks, that if they have the status "Submitted" and the submitted date is in March then it would calculate the value. Currently it is saying its #unparseable =SUMIFS([Submitted ($)]:[Submitted ($)], [Status]:[Status], "Submitted", [Date Submitted]:[Date Submitted],…
-
SUMIF with dates that land in a specific month
Im trying to use the sumif function to match 2 columns of data, transaction type, and corresponding value then return only month specific dates read from a date column. Date column is in mm/dd/yy format.
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…