Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Archived 2017 Posts


Discussion List

  • Re: Task Alerts
    In Archived 2017 Posts
    I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…
    139 6
    Closed 139 views 6 comments Most recent by FEspo
  • Renaming a Report through the API
    In Archived 2017 Posts
    Hello, Is there a way to rename a report through the API? Thanks, Nathan
    143 4
    Closed 143 views 4 comments Most recent by tsisson86006
  • Smartsheet API report creation
    In Archived 2017 Posts
    Hi,   We have a lot of reports, they have only small differences. Normally it is just a filter e.g. name of "assigned to".   If we have to slightly change these reports, we have to change all the reports by hand. Is it poss…
    245 7
    Closed 245 views 7 comments Most recent by Paul Labedan
  • Filters on Reports
    In Archived 2017 Posts
    I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added …
    968 19
    Closed 968 views 19 comments Most recent by Rhys
  • PROPER Function to change ALL CAPS to All Caps
    In Archived 2017 Posts
    I have a very long sheet where all text was written in upper case.  I know the UPPER and LOWER functions will change the entire sentence to lower case, but is there a PROPER function (like in excel) to capitalize the first letter of the se…
    1128 3
    Closed 1.1K views 3 comments Most recent by mdFleet
  • How to Sum Cells with Numbers & Text
    In Archived 2017 Posts
    Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell wit…
    13254 17
    Closed 13.3K views 17 comments Most recent by PrarthanaP
  • Is There Really No Built-in Log\NL Function?
    In Archived 2017 Posts
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    218 2
    Closed 218 views 2 comments Most recent by Ford
  • Formatting automated email notifications
    In Archived 2017 Posts
    Hi Team,   I'm wondering if there is a way to change the detail in the subject line of automated email notifications?   Also, can we choose what data is shown in body of the email? Perhaps change layout etc?   Thanks Kylie
    2694 21
    Closed 2.7K views 21 comments Most recent by Michelle Young
  • Sights Dashboards - gantt chart reports are formatting weirdly
    In Archived 2017 Posts
    Ok I don't know what other term to use...but on every dashboard the gantt chart reports have all reformatted themselves to make whatever column in the middle of the report HUGE...and shrinking the gantt chart part to a very small and kind …
    614 50
    Closed 614 views 50 comments Most recent by Madyson Morris
  • Auto Refresh Data?
    In Archived 2017 Posts
    I have developed a web form for a sheet I am using to collect production data from our production lines. I am then using a smartsheet sights to display production data on a dashboard I have published. I may be wrong, but I think the shee…
    4152 17
    Closed 4.2K views 17 comments Most recent by Andrée Starå