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 January 2017
Discussion List
Google Contacts Import
The Google Contacts import process needs some fine-tunning. For those of us that have several hundred or even thousands of contacts, we need a way to filter the import. A couple of suggestions: 1. By Google Group: this will allow us to select which group to import into SS. 2. By query: say I only want to import everyone in…
Two SmartSheets
Hi.. I work at a Company that just purchased Smartsheets enterprise edition. Some of our userbase have been using smartsheets before the purchase. Before the Enterprise purchase we had two different groups with their own smartsheets setup. When the purchase was made one of the groups was upgraded to the enterprise version.…
Lookup if date is between 2 dates, then return an associated value (same sheet)
Hello:) Is there a way to lookup a date, determine if it falls between 2 dates (fiscal year quarters), and then return the corresponding value? ie: Date: 1/29/2016 Fiscal Year Q1: 1/1/2016 ~ 3/31/2016 Fiscal Year Q2: 4/1~June 31/2016 etc So, the formula would check to see if {date} (1/29) is between 1/1 and 3/31, or…
Roll-up distinct selections in dropdown to parent row
Is there a way to roll-up child dropdown selections to the parent row so that the selections show only once in the parent? Example: Dropdown contains: Red, Blue, Yellow Child 1 selects Red Child 2 selects Yellow Child 3 selects Red I found where I can use JOIN(Children()), but this will display Red, Yellow, Red in the…
Strategic planning templates
Has anyone ever used a SMARTSHEET Strategic Planning Template? If so, how did you download it and add it to your account?
Counting Checked Boxes
I am trying to sum up the total number of boxes that are "checked" in a row. I would like to set it up so I have a cell in column 4 row 2 with the total number of checked boxes in that same row. Is that possible?
Conditional Formatting Help
Is there a way to highlight a row when a box is not checked by a certain time. We are trying to use as sort of a time clock, and our boss wants a way to easily track who is not on time. For example, making the row highlight to red if the box is not checked by 8am. Does anyone know a way to do this?
Use of one sheet as List for other Smartsheet
I am trying to select Project names in my action tracker smartsheet. The Project names has been maintained as separate Smartsheet. How to link Project name sheet as List in my action tracker sheet.
Changing Duration to Hours changes my Finish time
Hi all, I am having a problem that needs your assistance. Most of our projects are done in hours over a number of days. I have changed the Duration to hours instead of days in my sheet but what it then does is change the Finish time. How have you corrected this? Your assistance would be greatly appreciated
Deleting Cell History
Hi SS Users, So I have been busy setting up a whole lot of sheets, reports and sights - and been testing them extensively before we roll them out to users. As part of this testing, I have been typing in 'testing data comments - and some random made up stuff' into cells to test formulas, linkages, notifications etc etc.…