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 November 2017
Discussion List
Resource View / Completed Projects
If a task/project assigned to a person has been checked off as 100% complete before the assigned deadline, is there a way for the Resource View to update in order to show that person being available during that time, without going to the sheet and updating the duration/end date of the task? This way that person could be…
Improved Way to Alphabetize a List Using SMALL()
I have a project dashboard that links in data from several other sheets to show an overview of project financials and time charges. In a couple of cases I needed to sort the results by project number which includes four numerical characters, occasionally followed by a single alphabetical character, none of which I could…
Maximum number of sheets pulled into report?
Theoretical question - is there a maximum number of sheets I can use to pull data into a report? Say we have 300 active projects that all require their own sheets, but I'd like a report to pull a specific set of data from each of those projects (therefore each of those 300 sheets). Will that be an issue? We've yet to…
Do People Share Templates?
In reading the Pacific West Land Property Management success story, it appears they have created a template that would be extremely close to what I am looking to do. Do users share templates so we all do not have to reinvent the wheel? Thank you!
transfer user between accounts
Hi, I have 2 accounts, one with TEAM license, second with Business. I'd like to transfer 3 users from team to business how to do it? when I'll delete them in TEAM do they lost their sheets? or can I delete them in TEAM and add in Business without lost any data?
COUNTIFS and with 2 different values in same column?
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result. The most straightforward formula I've…
API - Bulk Operations Documentation
Does anyone have or know where I can get some information or an example on the Bulk Operations for the API? I am writing an app that outputs data to SmartSheet, however it seems to be a bit quick for SS as it throws errors saying it's already being updated by another process. It only succeeds if I put in a 300 ms delay. So…
Report Builder / Expanded Folders
I'm building a report for a Sight that will have the "Where" data updated often. right now, when I click Where, every single folder is expanded forcing me to close them one at a time and slog through a shared workspace that has folder I do not want to pull from. Is there a way to have all of the folders Closed by default…
Not sure why I'm getting Invalid Data Type
Hello! I'm trying to check a box to send an notification to our PM if: 1. column A [Best Day and Time for Service] is less than or equal to 7 days away 2. Column B [1st Visit: Date] is blank AND...if column A is blank, to leave the box unchecked. When I put a date in Column A, it returns "invalid data type" in my column…
Identify all cells that contain a formula?
I'm trying to look at all my formulas and am wondering if anyone knows of a way to (temporarily) highlight or identify every cell in a sheet that has any kind of formula in it.