-
Index or MATCH formulas
Hello I think I need an INDEX and MATCH formula. Basically I have 3 lists, broken down into Region - list of 7 names ICS - list of 42 names Trust - list of 100+ names What I want to do is when I select a Region (ie Midlands), it will then select the ICS list under that Region for me to choose from. Also when I select the…
-
Can't Find Option to Reference Another Sheet with new AI-enabled design
I was a away from Smartsheets for a few weeks while switching jobs and I can't find some stuff now. A month ago, when doing formulas that had the capability for a cross-sheet reference, Smartsheet would offer you a link to "Reference Another Sheet". Smartsheets a month ago: Now, when I try to use a formula, a pane on the…
-
Dropdown Link to another sheet is not working
I was able to successfully set this up last week. Today it is not working. I created two dropdown columns referencing two different sources into a single target sheet. This is still working correctly. However, I am unable to create any additional linked dropdown columns as of today. In the column properties I can access…
-
JOIN + ACCOUNTING
Hello, SmartFam! I'm trying to join text with accounting numbers. but the join will not keep the financial formatting (removing the $ and correct , placements) Can you please help me get this right? VENDOR AMOUNT JOIN RESULT DESIRED RESULT AMAZON $435,678.90 AMAZON - 435678.90 AMAZON - $435,678.90
-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…
-
Adding sequetial number string
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
-
Unable to Count Blank/Empty Cells in a Column
I'm trying to count open/active events that have not been Resolved. Each event is on a separate row with a column called Resolved. Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date) 3DEC 0859 ET…
-
CountIFS
I am having a problem with a formula. Does the COUNTIFS have a limit on the number of "logical expressions" used in a formula? My formula below: =COUNTIFS({Opportunity and task orders}, <>"", {2025 Opportunity Status}, OR(@cell = "8.0 - Lost", @cell = "9.0 - Client Not Selected", @cell = "5.0 Awarded Contract Vehicle",…
-
Average with exceptions
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
-
Trying to add a year to this formula
So here is my current formula… =COUNTIFS({Date Completed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Staff name}, =Staff@row ) This works. It gives me a number for all observations submitted in the month. The problem is it also counts the month for the previous year. How do i filter the count by month and year? Thank…