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.
Discussion List
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
Lookup Function-bottom to top
Is there anyway to use lookup function to find the match from bottom (most recent) of the table rather than finding the match from top?
Smartsheet ENGAGE Conference
Our first annual conference, ENGAGE, is well under way! It's great to connect with other Smartsheet users at the conference, but you can also follow the action on social media. We've got some great things lined up, be sure to follow Twitter and facebook to get updates on ENGAGE.
Link out to <Unknown Sheet>
Hi, Recently a number of links between two sheets that I use have been broken. It is not consistent (not all of the links were broken). Are there guidelines on why links could have gotten broken? Thanks, Brent
Filters
Hello, I have a Master sheet setup w Task Names being my customer column. From that I have filters setup for each of my processes which is in the Assigned Column. The filters for example will show all the jobs on the finishing calendar. What I would like to do is setup a filter that would show all the processes for one…
Conditional Formatting using python API
Are there any examples of adding conditional formatting to a sheet using the python API? Google search did not turn up any. Thanks, Paul
Link to an uploaded file
Hello, if I have uploaded a file to a row of one of my smartsheets is it possible to link to that file from a site. If so how is this done. Thank you
Formula Help
I have the following formula in a cell =([Actual Case Rate Achieved]57 / [Expected Hourly Case Rate]57 * 1) This data in the cells "Actual Case Rate Achieved" & "Expected Hourly Case Rate" are not always filled in at the same time, so when information is missing I am gettignthe error "#invalidvalue" I would like my formula…
Can I choose the choose the destination sheet for Google Smartsheet Sync?
I'm using a Google Form to populate a Smartsheet via the Smartsheet Sync. I had to unlink the destination Smartsheet (Sheet1) and then created a new link to a different sheet (Sheet2). I'd like to relink the Form so that all responses filter back into Sheet1. Is that possible? Thanks!
Fill formula's with Zapier
Hi all, At my job, we have been using SmartSheet for a while to manage our service projects. I am now starting to use Zapier to automatically create a new line for a project in SmartSheet once an upportunity is accepted in our CRM system. However, the autofill formula functionality does not seem to work whan creating a new…