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 February 2017
Discussion List
Cannot Login from China
Hi, My colleagues from China cannot login to SmartSheet start from yesterday afternoon. Before it was OK. He tried from different computers, also tried clear his borowser's history and cookies, but still failed. Then we asked friends from other cities in China tried to logon, they all have similar problems. They can open…
Exchange Server 2010 or 2013 (On prem)
Any update on support for on premise implementations of Outlook platforms (Exchange 2010 or 2013) integrating with SmartSheet? We won't be utilizing Office365 at our firm. Thanks!
Formula Help Needed
Hi everyone, Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out. I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is…
Cannot upload or download documents!
is anyone else having trouble uploading and downloading documents on smartsheet??? Noone on my team is able to do this very simple thing on smartsheet. Please help!
Sending data to another sheet leaves formulars behind.............
Hi Team, Now that i have a sheet that completes the sales process from contract through too invoiced/paid. The row needs to go to another sheet, I noticed it leaves the formulas behind and when i send it back to the original sheet I have to re-enter formula in cells Can i duplicate a sheet so all the data and formulas…
Live Data Connector and Spotfire
Has anyone had success with using the Live Data Connector with Spotfire webplayer? I have been able to use it fine with the desktop client, but it doesn't seem to work well with the Web Player.
Rounding up the results of an IF formula
I finally figured out how to create an IF formula to get an AVG of Children divide that by a specific number, and enter "N/A" if there was nothing in the children cells. NOW my boss would like to Round the resulting number up to the next dollar value. Sometimes, I think she just likes to test me! LOL Here is the formula I…
COUNTIF Formula Help
Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column says CLOSED. This is the…
Line Break as Delimiter in JOIN(CHILDREN()) Formula
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this? 2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents. Example Values for Primary Columns for two rows: Child 1, Child2 Value for relevant text cell of child 1: - lorem…
Formula Malfunction!
Has anyone every had a situation where a formula in a cell calculates improperly if it references a cell whose value is also derived based on a formula? I have a formula set up where it's looking at cells in the current and previous rows to calculate total hours worked in a day. (I borrowed this formula from one of you…