-
Counting instances of a request that meets certain conditions but it's not counting sequentially?
Hi, I'm trying to count the number of times a request appears that matches certain conditions. I want the first instance it appears to be 1, and the second instance to be 2 and so forth. Right now, this is what I'm getting when I filter for the requests that meet the conditions I'm looking for. I don't know why it jumps to…
-
I am trying to create a column with all emails associated with a certain name in the column
HI, I have a problem where I need to give access to certain rows of information to people in the same group. I have a smart sheet set up right now that looks something like this. I am looking to put all of the emails in group 1 into the access column so that I can have only people associated with the group to be able to…
-
How to use if contains with similar words
I want to use if contains to find a word and classify it The problem I have is they are to similar it will always Classify it as A and not B. the description is to long for Has or just a regular if Statement. =IF(CONTAINS("EOR", description@row), "A", IF(CONTAINS("BOR", description@row), "A", IF(CONTAINS("CBOR",…
-
Text to columns in Smartsheet
I have a cell with multiple values separated by commas. (eg. A, B, C, etc.) I want to try get these separate values in a column: eg. Row 1 - A Row 2 - B Row 3 - C and so on.. PS. There is no limitation on how many values this cell has. It can vary from no values to up to 40 values.
-
How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company. They've not been able to provide the level of reporting my SLT is requesting. How can I create a dashboard from that project without doing any changes or calculations, summaries within their project? They did make me an…
-
#INVALID VALUE Error - Can't figure out why...
I am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH(Auto@row, Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amount: Text/number column =INDEX({Job Tracker Invoice Amount}, MATCH([Invoice Number]@row, {Job Tracker…
-
Formula to delete specific values from a multi select dropdown column
Hello. I have a COI Tracking sheet that tracks insurance by vendor, which includes a multi-select dropdown column that lists all of the job numbers that the vendor needs to supply insurance for. I have one column for Current Jobs, and a column for Expired Jobs. I have a secondary sheet called Closed Jobs that tracks…
-
Trying to count if data range falls between two dates.
I have a sheet with StartDate and EndDate fields. I want to count actual items opened on a separate sheet if the date falls between the start date and end date. The below formula keeps returning #UNPARSEABLE and I suspect its something minor. =COUNTIFS({Request Tracker with Form Range 1}, "<=" & (EndDate@row),{Request…
-
Autopopulating Dates Based on 2 Fields
I'm struggling. I have a workflow to auto-populate the created date. I have another column that determines the type and length of review requested (3 days, 6 days, or 12 days). I would like to auto-populate to a specific submission date Mondays at Noon to be discussed at a recurring meeting on Wednesdays, so it would be…
-
Custom Auto Number Formula
HI Community I need help creating a custom auto number formula using set prefex and a reference column. The DRN "number" or Identifier must populate as follows: ABCDE-DRN24-020T. The prefix 'ABCDE-DRN' is absolute for all numbers and the '24' after DRN is referencing the FY Reference column year. The next 3 numbers after…
