-
List all unique values from a column within one Smartsheet in a separate Smartsheet
Hi All, In my Smartsheet I have a column for Workstream - each row (deliverable) in the Smartsheet has a Workstream - there could be one or numerous Workstreams. In a seperate Smartsheet, I want to be able to pull all Unique values from the Workstream Smartsheet. In Excel I would simply do something like -…
-
Percentage in a formula
Hi, Happy New Year! I got stuck with what I thought was a simple formula and I'm hoping you can help me. We have three different thresholds that I need to use to change the RYG balls: Above 3% - Red Between 0 and 3% - Yellow Below 0% - Green My formula looks as below: =IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.3,…
-
Data Trending
I am working on a project sheet. I have a cell that is made up with data that is submitted by a form. The form has around 30 different drop down items. You can only select one item from the dropdown list at a time. Here is the issue I have. In cell "A", I might have the same text "You" listed 20 times. Then it will switch…
-
How to pull data from one sheet to another easily
Hi everyone, I manage smartsheet for my company even though I have nothing even resembling training in spreadsheet manipulation, formulas, etc. So I'm just learning on the fly. We have one sheet that has all of the projects we are currently working on, listed by project number and then a bunch of data specific to the…
-
Formula to add leading 'zero' to IDs
I have used these formulas individually and they work, but need to combine as an OR statement =IF(LEN(MSID@row) = 2, "00" + MSID@row, MSID@row) =IF(LEN(MSID@row) = 3, "0" + MSID@row, MSID@row) =IF(OR(IF(LEN(MSID@row) = 2, "00" + MSID@row, MSID@row), LEN(MSID@row) = 3, "0" + MSID@row, MSID@row)) But the combined formula…
-
Formula Won't work
What am I doing wrong? I can't get this COUNTIFS formula to work!!! I have tired so many iterations. A note that the "Opportunity For" and "Cycle" are referencing a column in a sheet. This works: =COUNTIFS({Opportunity For}, HAS(@cell, "Minority")) This works: =COUNTIFS({Cycle}, HAS(@cell, "FY24")) I CAN'T GET THIS TO…
-
Count Function Error
Trying to count the number of times there was Giving before 01/01/24. Using the function shown, it yields 0. If I change < to show count after 01/01/24, it gives me 9 instead of 2. What am I doing wrong? Thanks for your response.
-
COUNTIFS and ISNUMBER Formula Help - How to count a cell only if the value is a number?
I have a form that is a series of questions regarding requirements. Some requirements will apply to some sites and some will be N/A for some sites depending on what each site is set up for. When a requirement does apply, there will be a scoring system associated with each requirement which will result in an adherence score…
-
3 out 9 Sheets take 5 Minutes or More to Load .... Why?
I have built a preview process for Marketing Materials that contains 9 sheets. The sheets contain automations and not all sheets are connected. All of the sudden 3 of the 9 sheets are taking 5 minutes or more to load. It is happening for the entire team, not just myself. It happens a home and in the office. It started with…
-
COUNTIF in the same sheet
I have two columns "Associate Name" which contains a list of names, and a corresponding list of birthdates "Date of Birth", both ever expanding. I would like to have a column that counts the number of times which that associate name and birthday appear in the sheet. So if I enter "John Doe" and "1-1-24", the first time,…