Using Smartsheet

Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.

Discussion List

  • Calendars
    In Using Smartsheet
    2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO.  Can I create just calendars?    I created an installation sheet and a service request sheet.  Is there anyway to merge the 2 calendars and color code t…
    33 1
    33 views 1 comment Most recent by Chris McKay
  • Multiple sheets consolidate in a hierarchical single sheet
    In Using Smartsheet
    We have sales team members having their own sheets to capture their client info and industry-specific potential billings. Please see attachments exec1 and exec2 Is there a way for the Sales Manager to view all of this in a single sheet th…
    245 8
    245 views 8 comments Most recent by J. Craig Williams
  • Editing Labels on Charts
    In Using Smartsheet
    Is it just me or are we not able to edit the chart labels anymore? They just brought out a bunch of a new charts and I can't seem to format word/number like I used to.
    490 1
    490 views 1 comment Most recent by Chris McKay
  • Automating RYG balls based on Due date and completion status
    In Using Smartsheet
    Im having an issues creating this formula and was hoping someone could help improve on my formula.  Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and …
    116 1
    116 views 1 comment Most recent by Chris McKay
  • Error message - publishing SmartSheet calendar to Outlook
    In Using Smartsheet
    I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message i…
    51 3
    51 views 3 comments Most recent by Chris McKay
    In Using Smartsheet
    I wrote a function for my budget, setting limit and i want it to return text either True or false. but it kept on returning "INVALID COLUMN VALUE" (=SUM(A3:A10)<=(0.7*D6)
    3454 2
    3.5K views 2 comments Most recent by Chris McKay
  • Form not capturing submissions
    In Using Smartsheet
    Hi, Am experiencing an issue on a brand new sheet/form where submissions are not being captured. No filters. No hidden columns or anything. Shows that five entries have been submitted (all my tests), but nothing is showing up on the grid v…
    38 4
    38 views 4 comments Most recent by Mike Wilday
  • Enhancement Request: Dropdown for Forms
    In Using Smartsheet
    Quick request, likely will come to naught, but here it is: Several uses cases recently require designs with multiple forms. Useful would be a convenient way for end-users to access them (for submission, not editing). Perhaps a dropdown m…
    11 2
    11 views 2 comments Most recent by Mike Wilday
  • Updates are not visible
    In Using Smartsheet
    I have a MSFT- Promo account and a month ago I created recurring Update Requests that are being sent out to my 17 customers. Since the upgrade last week, I cannot find the Updates that I created but they are still being sent out (yes, I ch…
    12 2
    12 views 2 comments Most recent by DajO
  • Reminder issue?
    In Using Smartsheet
    I have 20+ sheets with various Due Dates on various rows.  I have a reminder set to send the Preparer a reminder when the Due Date occurs.  Historically, the email notification only shows the rows that are the actual "Due Date". …
    Ian Profile Photo Ian
    34 15
    34 views 15 comments Most recent by Mike Wilday