-
feeding SmartSheet data to Google Earth
Hi, I'd like to take survey data entered into rows of SS and output it to Google Earth. Obviously I can do this with exports from SS and imports into GE, but I'd like to be realtime. Is this even possible? Is anyone doing something similar?
-
Screen blurs for lengthy formulas, or multiple parentheses
Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…
-
Unrecognized or Invalid Emails??
When sharing sheets between My account and Others(business partners/clients), I often run into unrecognized email accounts warnings/alerts... (and I have to drop what I'm doing and setup a contact in "My Smartsheet Contacts"). Wondering how common of a need this might be. I might invest a bit of time to come up with a…
-
Build cashflow from multiple projects
I would like some help (happy to pay) to enable our company to map task and revenue budgeted for each task and then have the data feed into a cashflow sheet somehow. Could someone help me
-
card view in Sights
please add the ability to add card view to Sights. It seems like this would have to be added to reports since that is what is used in Sights. However, however it can be done, this feature needs to be part of Sights!
-
Transfer automatic data from SmartSheet to ERP
Hi, We would like to test SmartSheet for as a order follow up system. Whenever we are entering new orders, we need to transfer the informations to our own ERP system automatic via an API solution. Is that possible with SmartSheet?
-
# of Attachments in a Cell
I would love to log the amount of attachments a line has in a cell. IE 3 attachments, I would like to have one of the cells read "3" so we can at a glance see how much documentation is added to the line. Does anyone know if this is possible with Smartsheet?
-
Restricting dropdown lists using VLOOKUP
Depending on values in one column I want to restrict the dropdown list in another column Example: I have a sheet: Employees Role Name ------ ------------- PM Jane PM John Dev Mark Dev Stephanie In another sheet where Tasks I have these same two columns Role and Name Once I enter the Role (say PM) it should automatically…
-
Excel Live Data Connector - Partial Results Returned
Hi, On Smartsheet the report returns all rows. When I export to excel it returns all rows. When I run the connector in Excel, it excludes some rows. It appears that the rows being excluded have a Text/Number value in column X i.e. D21, whereas the ones being returned just contain a number in column X i.e. 1901 - so I…
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
