-
Sorting sheets in a workspace
As of this morning, I have found that Smartsheet is defaulting my sort order to Name. I can change to Last Update on a specific workspace, but when I click into another workspace, it defaults back to sorting by Name. Previously, the sort would stay with the last setting. As I prefer to sort by Last Update to quickly see…
-
Sorting Recently Opened File List
Is there a way to sort the recently opened file list, especially those "pinned to the top"?
-
Importing a .csv file as a smartsheet via the API
Hi, When I import a .csv file via the API, some of the column types are thrown off. I have one column that is strictly text (should have the type TEXT_NUMBER), but smartsheets is assigning that column the column_type PICKLIST. How do I prevent this from happening during import? Having to always import, then find the…
-
Rounding down based on week ending date?
Hello, I am trying to recreate this formula from Excel into my Smartsheet: =ROUNDDOWN((DATEDIF([@[Leave Date]],[@[Week Ending]], "d") / 7), 0) It is supposed to subtract 7 days from the Week Ending date. How can I make this work in Smartsheet?
-
CUSTOMER ACCOUNT STATEMENTS & TRACKING
Hello folks, I would appreciate some assistance on the following. We run a 'Savings Club' for circa 50 customers. We use excel to track saving credits, purchase debits and running totals using a tab for each customer and a summary sheet to give an overview. See attached snip of a sample statement. I would like to use…
-
Any way to display task names on a Resource View
I want to be able to see a view of all my staff with their associated tasks across all projects. Currently the Resource View does this except it does not label the tasks, it simple shows allocation percentage. Is there any way to get those items that simply list as percentages to show the actual task name? Or is there any…
-
Using multiple filters within one sheet
I am using a sheet as an employee resources database for links, training, graphics, documents, etc. since there are currently 400+ items in this sheet I started creating filters to help employees navigate specifically what they are looking for. Currently the only way I have found to do multiple conditions to a filter was…
-
Link turning red and voiding Hyperlink
Good morning, For our smartsheet we have a hyperlink to a bunch of procedure documents in a column that needs to be clickable on each row. Recently on some of our sheets and some rows what use to automatically hyperlink now turns red and is not clickable. Making it so I have to manually create the hyperlink, which you have…
-
Weakest link formula assistance
Hello! I need to ask for some help. I am trying to set up a Weakest link formula. We would like to use Red, Yellow, Green for Health for each task and have a Weakest link formula at the Activity/Milestone level. * Once a task is complete we will manually use a Symbol column with a Star to indicate completion. * If a task…
-
Contact List Drop Downs
Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't even see John Doe as an…
