-
Countifs + contains with reference form another sheet
Trying to reference another sheet with the COUNTIFS + CONTAINS formula and am getting this #INCORRECT ARGUMENT SET Here is the formula I am using =COUNTIFS({ReturnOrder}, Date@row , CONTAINS("STS", {Companyname}))
-
How to quickly find a column by it's name in a sheet?
I have a very large sheet with many columns coming in from a form and many additional helper and result columns. I have created documentation of how it is working where I document the column named, its purpose and the formula used. (In addition to adding information to the column description). I am curious if there is a…
-
Jump to column feature
One of my biggest pet peeves is when a Smartsheet is set up with the first row as column names so that you can control + F column name. Without it is a nightmare of sorting through all the different columns trying to find a specific column looking for, so I get it, but I just don’t like it. Fix it, please Smartsheet. I’m…
-
My Sort Option is Greyed Out
Hello, For some reason, I am unable to sort my columns. I am attempting to sort my first column alphabetically. When I right click on the columns (any) the sort option it greyed out. My other column have drop down settings. I appreciate any help!
-
Separating Text Formula
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…
-
How do I get Summary Totals to appear on the pdf attachment?
I love the enhanced report features with the grouping and summary totals. But when I send this as an attachment, they disappear? Is there a way to print and save the report to an attachment so that it presents the designed view? Thanks for your help! Sheila
-
Lengthy text value in dropdown not a pickable option in certain filters
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
-
deactivate vs remove user?
What's the difference?
-
Resource Management Advanced reports grouped by month should include Month or Month/Year as a column
Resource Management Advanced reports, when grouping by month, should include Month or Month/Year as a column. I tested both grouping by week and by month (both options for group by), and they produce the exact same output advanced report data even though the report inside of the RM module shows YYYY/MM grouping. The Time &…
-
Add contact in drop-down in Table View
I would like to be able to add contacts in the drop-down view of a contacts column in Table View. I can do this in Grid view just fine; however, the only similar function in Table View is to edit column properties and add only an email address or a name. This does not allow me to add both a name and an email as in Grid…