-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
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…