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.
Re: Task Alerts
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 included the following columns in my sheet so; * a date column for when activity is due…
Renaming a Report through the API
Hello, Is there a way to rename a report through the API? Thanks, Nathan
Smartsheet API report creation
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 possible to create/change reports with the API? I tried to do it but i did not found it in the API…
Filters on Reports
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 to the future enhancements list. Thanks, Steve
PROPER Function to change ALL CAPS to All Caps
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 sentence with the subsequent letters in lower case?
How to Sum Cells with Numbers & Text
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 with the following formula: =15 + " min" Result: 15 min When I add 2 cells with that formula [=15 + " min"] + [=15 + "…
Is There Really No Built-in Log\NL Function?
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 Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
Formatting automated email notifications
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
Sights Dashboards - gantt chart reports are formatting weirdly
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 of dumb looking last column. I love you Smartsheets --but you are making it almost…
Auto Refresh Data?
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 sheet that the data is being sent to needs to be manually refreshed so that the sight will…