Sheets
Discussion List
-
Formulas to identify duplicatesIn Formulas and FunctionsMy company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick gla…Answered - Pending Review 16 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Error code 5570 when sending e-mail notificationIn API & DevelopersI have a trial account with Smartsheet. I am using smartsheet API with curl to create/update few sheets. The requirement is to email these sheets at EOD to a couple of users. However, receiving error code 5570, 'you have exceeded maximum n…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?In Using SmartsheetIn other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…Answered - Pending Review 15 views 3 comments 0 points Most recent by Scott Rapoport Using Smartsheet
-
This new layout is awful, can it be made optional?In Using SmartsheetWhy would you do this? Did you even test this with customers? Why can't I open as a new tab from the "home" page? Why can't I make the "home" page the default on the side bar? Why can't I make the side bar stay open?…
-
Possible to create columns within columns?In Using SmartsheetIs it possible to create columns within columns with a checkbox in each of the sub-columns as below?
-
Tracking form responsesIn Using SmartsheetHello all, We have a situation where we need to collect information from our customers to complete certain tasks for their projects. We would like to enter data in a column or two (i.e. sales order number, product sold), and then have the…
-
Conversations (notes) now in reverse order & entry too smallIn Using SmartsheetI frequently create notes for line items via the Conversations feature. Until recently, these conversation notes always sorted from most recent to oldest entries. In addition, the field space provided for entering notes was larger and high…
-
VLookup #No Match ErrorIn Formulas and FunctionsI am looking for guidance for the utilization of the VLookup formula. I have formatted this formula within one of my Smartsheet sheets and I keep getting the #No Match error message, I have verified this information already: 1) Range to r…
-
Auto uncheck at the end of the day.In Formulas and FunctionsIs it possible to clear a check column using Automation. We are planning to use this as a Evacuation check list. We are looking to have it cleared daily (Overnight)Answered - Pending Review 16 views 2 comments 0 points Most recent by Dan Naugle Formulas and Functions
-
Using HAS with Multi-Selection DropdownIn Formulas and FunctionsHi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the mult…Answered - Pending Review 3 views 1 comment 0 points Most recent by Mark Cronk Formulas and Functions
