-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Index + Match function - not working properly.
I've been using a simple index + match function to pull information from another sheet and for some reason on a new sheet the functionality seems to not work correctly. Specifically, it only correctly pulls the information for some of the rows. I went and sorted the row in the source sheet and got it to work, but we'd…
-
simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary =COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)") something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values…
-
I need to create a subset of the data on one sheet that can be actioned and then linked back.
Hi, I have one sheet that is a listing of all commissionable groups. The team processes the commissions from this sheet. Of those, there is a subset of agencies that we prepay 50%. We want to create a separate actionable sheet that pulls the data from the commissionable group sheet for only those we prepay. Once those…
-
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…
-
COUNTIFS with multiple criteria from multiple columns
Hi all, I have tried various different formulas from various posts on here but still keep getting Unparseable. I am trying to create a formula, linking from another sheet, to find the following criteria: If the row contains ANY of these values: "未着手 Not Started", "進行中 In Progress", "現場確認 Field Review", "保留中（予算）On Hold…
-
Need to calculate a date based on data in another sheet
I'm creating what is basically a notification system that's too complicated for just Automations. In a one sheet I've set up a Cadence by a Category. So the category might be Webinar. The cadence is captured in multiple columns labeled First Push, Second Push, etc. Each of those houses a number representing the number of…
-
Using Index/Match to display multiple values in a cell
Hi there, I have two sheets and I am trying to use Index/Match to pull multiples values in a cell in Sheet 1, into another cell in Sheet 2. I'm using the following formula, but I'm only getting the first item in the Sheet 1 cell to display. Here's my formula: =INDEX({01 - Product Grouping}, MATCH([Product Name]@row, {01 -…
-
Help creating a formula that generates the current fiscal year
The following formula is #UNPARSEABLE. I'm not sure why. Please help. =IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))
-
Multiple cells locked to single formula in same column
I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows that reference that cell in the same column so I don't have to copy the tweaked @row + Parent, Children, or Ancestors…