-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
6 Month Anniversary Formula
Hello Everyone, I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!
-
VLOOKUP on a multi-select column
Hello, Say I have a multi select column with 4 possible choices (North, South, East, West). If North and South are selected, is it possible to write a VLOOKUP to pull the first selection, and then write a second VLOOKUP to pull the second selection? In other words, is it possible to parse multi-select columns? Thank you.
-
I am trying to create an IF formula with a +/- range!
Hello! I am trying to create an IF formula where if the value is 40% with a range of +/- 2%, it is a pass. If it is any percentage outside of the range (38%-42%), then I was it be a fail. Here is the chart in reference! Any help would be amazing.
-
Stacked bar chart formula using COUNTIFS and HAS functions
I have created a helper sheet to use for building a stacked bar chart. The sheet data should count how many open tasks an individual is assigned to from two different sheets. Because there may be multiple contacts in an Assigned To column, I need to update this formula by adding HAS. I cannot get it to work correctly in…
-
Date Formula
Hello! I have created a sheet, that based on the month, a workflow will be triggered to send an email out on a certain date. For example, if the month is August, Sept or October, an email be triggered to be sent on 12/15/23. If Nov, Dec or January is checked, then the email will be triggered to be sent on 3/15/23.…
-
Formula to count # of dates per month in a date column
I am trying to create a formula that will tally, by month, the number of date entries in a column. (See screenshot attached). Our non-profit provides ongoing financial counseling to veterans and each person is counseled more than once throughout the year...so I want to be able to tally each month how many new veterans we…
-
Help with a status health formula please
Hi All, we have developed a fairly basic formula to determine the health of tasks: =IF(Status@row = "Complete", "Green", IF(Status@row = "Canceled", "Green", IF(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started", [End Date]@row <= TODAY()), "Red", IF(AND(Status@row = "On Hold", [End Date]@row <=…
-
I am trying to figure out a COUNTIF with AND formula while referencing another sheet.
I am trying to create a formula that counts both if the base health is green, and if it is in shift 1. I will be doing this for all of them. If they are red in shift 1, yellow in shift 1, green in shift 2, red in shift 2, yellow in shift 2, green in shift 3, yellow in shift 3, and red in shift 3. Here is the exact part of…
-
How do you return blank if information is not found on index(match) function?
I am trying to create a cross reference formula that will link information from one sheet to another. The first sheet (Roster) that has a bunch of position data, including the position number. The second sheet (Validation Form) will be collecting additional position data over the course of the next year and it also…
