-
Require Help with COUNTIF Formula on Smartsheets
Hello everyone! I am trying to count the number of records for the current year(2021) from 'System Generated' date column -(Request Date )with formula - =COUNTIF(Request date: Request date, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) in the 'Sheet Summary' section. This is not working - says #UNPARSEABLE Alternatively I have…
-
Countif the Year 2021 on a Column Returns #invalid data type or zero.
https://app.smartsheet.com/sheets/xXvWq9JrWMjRXGHv7jcV4Q4GF45wJWc4C32GcHw1
-
If Not Blank Statement Help
Hello, I am trying to write a Column Function If statement in the "Task Status" column that will update my status to be "Complete" or "Incomplete" based on if certain cells on my smartsheet are blank or not. So far this is the formula I've put together, but I can't quite get it to work. Would somebody be able to take a…
-
Find Unique Dates from 2 Date Columns
Problem of the Day: I have 2 date columns with different dates. I want to create a 3rd column that lists only the unique dates from both columns. Suggestions?
-
Drop down multiselect column - getting count data
I have set up a form with a multi select list and I need to be able to tally the selections against each of the items. I have looked on here a lot and tried various versions of COUNTIF and COUNTIFS and COUNTM and have exported to Excel and tried to do it that way and cannot figure out what to do. Can someone point me to…
-
Number count formula
Hi All. I have a column of data that is strictly numbers. I am trying to build a formula to look for duplicates and also at the same time not count any blanks in the column. The normal formula i would use for this is =COUNTIFS([Column Name]:[Column Name],AND(@cell = [Column Name]@row, ISNUMBER(@cell))). However some of the…
-
Formula to color RYG balls based on date/deadline
Hello, I'm trying to alter the color of our RYG status balls based on the proximity of the date. For example: Yellow - if today's date is within 5 days prior and 5 days after the deadline date noted Red - if today's date is 5 days + after the deadline date Green - if today's date is before the 6 days + before the deadline…
-
Subtraction across two sheets if row and column match
Hi community, I have separate sheets for tracking monthly budget and actual expenditures. They have identical layouts (see below). Problem is, the budget goes to 2024, so I really need a formula that can calculate the variance between budgeted and actual. The logic would be something like: =budget(where row = "Feas-591:…
-
Reporting Indicators
Hey All - I'm creating a graph in SmartSheets, and wondering if there's a way to create an indicator (line, tick-mark, etc.) that would show as part of the graph where I could mark certain changes. In this graph, I'm showing Employee Capacity vs Forecasted Time, and I want to indicate when an Employee either left/joined…
-
It's Only Blocked Until I Kick It
I have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it does, if I go into the formula and edit it (without actually changing anything), then the…