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
Archives for September 2017
Discussion List
SEND REMINDER ONLY IF TASK IS NOT COMPLETE
How do I setup a reminder to only email if the "Complete" box is not checked off? It seams that there is not a way to add a condition in the reminder setup.
linking to a template?
Is there a way to create a link to a template (other than using the API)? I want to put links to our templates on various sites so people don't have to remember where each template is stored in Smartsheet. Ron
c# Smartsheet API: Can Not Get ColumnId
I am trying to read data from Smartsheet using C# SDK. I can get sheet info but column details such as ColumnId are Null. When I run the code below, I can get sheet and its columns. Bu only column name and type are filled, other properties of columns are Null. What am I doing wrong? using System; using…
Updates from shared sheets
I shared a sheet with a team member and the information that was updated does not reflect on my master sheet. How do I get the updates to go to the master sheet?
Sight View
When the "people" symbols are imported into the sight view why does only 3 people show instead of all 5. All 5 show on the phone app and when you print the sight. Anyone know how to fix?
Count if date is last 7, 30, X days
I have a sheet that lists feature requests. The system automatically generates a date when the request was submitted. I have summary columns up top of how many features were requested Q1-Q4 but I would like to add in counts for the past 7 days and 30 days. I would like a formula so the counts automatically update without…
Engage 2017 Retrospective
Hello Smartsheet Community! I just wanted to thank all of you who attended the first ever Smartsheet user conference, ENGAGE 2017. If you weren’t able to attend the conference, but are interested in seeing the Keynote, the video is available on the Smartsheet website here. Of the highlights for me, one of the best parts…
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
Moving Massive Qty of Rows
Good Afternoon, I'm currently dealing with a minor issue with SS while moving rows. Once a month, we move a single months worth of data from our main Completed sheet to an Archive sheet I have created, to keep record of previous rows that have been marked complete past 3 months. I do this to keep the loading time down in…
Help with Sumif not recognizing criteria as a percentage
Hi all, Trying to create a field that will tell me what percent of a list of values have exceeded 80%. =SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7) Goal progress is a percent value i.e. 100% or 45% 80% Value is the number 1 Smartsheet is not…