-
Identify corresponding value and return
Good morning, I am not sure how to formulate this desire into a working function. My process workflow grid contains 6 columns containing a drop-down single select of around 50 choices. They are TEXT selects for descriptions. I want to identify the corresponding SKU from the text descriptions in a second set of 6 columns…
-
SUM by month
Hi guys, I'm trying to total income by month, and my formula is not working. Can someone please advise where I am going wrong? =SUMIFS({Fee}, {Date Received}, MONTH(@cell) = 10, {Date Received}, YEAR(@cell) = 2020) Where {Fee} is what I need to sum. I'm then trying to sum in November 2020 in the above example... Feel like…
-
How can I fix my sum formula ranged whenever I have new inputs from Forms?
Hi, I have sheets where I am collecting the data using the form. I have setup my form to put new submitted data at the top of my table. My problem is , when new submitted data was collected the range of my formula is being changed and not getting the new collected data. See the Total formula. Please help me to fix the…
-
Cross-sheet reference cells limited
hi all Is anyone have the same issue like this, one sheet reference other sheets and more than 100,000 cells will cause some problem? Thanks, Sherman
-
Multi-select string operation
Hi all, I have three columns which have the same drop down options: requested, received and pending. I would like the "pending" column to have all options from the "requested" column except for what's in the "received" column. For example: under "requested": option 1,2,3,4; under "received": option 1,2; under "pending"…
-
Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following: 1) AVERAGE the numerical values in one column. 2) IF the data was collected in a certain month, which is identified in a different column. So for example, I…
-
Autopopulate Date based on contract renewal terms
Hello, I am looking for a formula that would help with calculating a date based on dates and criteria in two other columns. Here is the scenario: I have a contract with an expiration date. This contract is auto renewed for a certain number of years (3, 5, 7). I would like to create a column that contains a formula that…
-
Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single…
-
How to use multiple NOT in cross reference formula
Hi, I am implementing a formula which is taking cross reference from another sheet, let the column I am using be Column1, Let it have 10 different values. I want to get the count from this column where the value is not String1 and not String 2. I didn't find any usage with multiple nots, can somebody help?
-
Duplication Issue
Hi, I have created to forms with logic, duplicated, and am trying to edit independently--but when I edit the one sheet it is changing the logic on the other sheet...what am I doing wrong? (I am teaching myself smartsheets, so this is my first sheet created :) )