-
Home ribbon, open tabs no longer retained across the top but rather in a single 'three dot' drop dow
Hello Fellow Cubicle Warriors, My Smartsheet interface used to keep tabs across the top ribbon, where the home button is going to the right, of sheets that I recently used. Now it rather stack them up into 1 tab with three dots, in a drop down style, next to my currently open tab.(please see my attached screenshot) Is…
-
VLookup reference to another sheet only returns errors
Why can't I return any values with VLookup? * On my customer sheet I have a column for Baseline Fee * In the Baseline Fee field, I enter =Vlookup * Click Reference Another Sheet * On my pricing sheet the columns are Baseline and then Fee (currency USD) * I've tried selecting Baseline and Fee columns, just Fee, just…
-
Quote Request to Multiple Suppliers
Hello, I am looking at finding a way to send a quote request to a chosen list of suppliers. Is there any way I can send a row with all of the quote information to multiple email addresses where it will create a new row for each quote returned? I can then review the prices before choosing which supplier to proceed with. Any…
-
Lock Filter so "Assigned to" can not turn off
I am looking to lock down a filter on a shared task sheet so that the assigned can only see their task. The filter has been setup and and applied as a rule to the sheet, but it appears that the assigned can turn the filter off and see all other task in the sheet. I do not want this to be happen, how can it be stopped? I…
-
Filters - "Assigned to" not able to turn filter off
I am trying to look at an issue around a filter that is created in a sheet that is set to Assigned To current user, yes when they go into the sheet they only see the task assigned to them, but they are also able to turn the filter off and see all task in the sheet which we do not want. I have added some screen shots that…
-
Uncategorized Column
I'm using the Card View as an intake workflow. Is there a way to rename the "Uncategorized" Column? When a new intake request is created via the form, I'd like the request to automatically go into a "New Request" column, not "Uncategorized". Thanks!
-
Text- Mid formula
Hello, I am trying to extract certain words from a string of text using the "MID" formula in excel. Is this something I can do in smarthsheet?
-
Formula to update status value
Hi, I would like to create a formula to update the value in the status field (it's a drop-down list). If the start date is in the future = "Not Started," if it's in the past = "In Progress," if it's 100% Complete, then "Complete." I've tried and get an unparseable error. Any help would be appreciated!
-
Inventory Sheet, moving data to/from Excel and SmartSheet
Hello all, While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help. Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and…
-
contacts
I have entered my smartsheet contacts manually including their email and name. Afterwards when using my contacts to send out update requests, only the email for the person is displayed for about 1/2 my list, the other 1/2 has both email and name. This display changes at times. I have edited their contacts and added the…
