-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Box Sync
Hi I needed to attach supporting documents from Box. I find it frustrating to do so because * I cannot use Box Sync (offline Box which syncs automatically with Box) to drop the links, instead I have to use Box Online * When I try to link Smartsheet to Box, I find it extremely slow as it needs to first load all the folders.…
-
Change RYG Automatically based on values
Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green: Any positive (%) Yellow: 0 to negative 10% Red: less than negative 10% With the below formula, green and yellow work fine but not red. How close am I? =IF([% OVER (-) UNDER (+)]5 > 0, "Green", IF([% OVER (-) UNDER…
-
Hyperion Link
Hello - Is there a way to link Hyperion directly into SmartSheet? New user and trying to determine the capabilities. Thanks!
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Enhancement feature - Merge Cells functionality
Wanted to start a thread for an enhancement feature to try and push this up in the road map prioritisations. For such a simple and standard feature in tools like Excel and Google Docs it has become such a barrier during the process of trying to migrate exsisting documents form the above tools to Smartsheets and now is…
-
Contract Managment
Has anyone created a smartsheet to manage contracts?, specifically to perform the below activities: * track total amount vs. payments * track payments against deliverable complete * track contract term * track contract amendments : to extend the period, increase the budget, adjust terms of reference, etc. * Track invoices…
-
Has anyone used Tempus by Prosymmetry?
My Smartsheet contact had recommended Prosymmetry to me for my companies resourcing and time tracking needs, and I'm doing due diligence and vetting. Can't find much information on this company including their seed funding or VC info. Has anyone else used this tool? What has your experience been?
-
notification for part of group
Hi, I have a smartsheet and I heard that I can set up notification rules and applied for all shared users. E.g. My sheet is shared with 20 people. There is a column in Smartsheet, "meeting date". I just want notification is triggered as meeting date is changed to any value. However, if I only want notification only…
