-
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
-
Duration in parent row not calculating
I have a parent row that is indicating duration of its child rows as 78,324 days when in fact it's actually 53 days--February 1 - April 29. (I made sure the dates were all in 2016). I had one row that was showing several thousand days when it was actually 21 days. I fixed that and saved the sheet but the parent row is not…
-
How to automate the predecessor?
Is there a way to automate the predecessor column? I don't want to manually enter each number.
-
Embedding URLs in a sheet...
Google Sheet allows this, Microsoft Excel allows this, even EverNote does -- why can't I embed a URL to a bit of text in a SmartSheet? OR, let me "attach" a URL to a row... it's mission critical for us and will have us not use/abandon our license with Smartsheet...
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
-
Formulas
I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Show changes made in the last 24 hours (only)?
Is there a way to have a smartsheet highlight only those changes that have been made in the last n hours? I look for changes to one of our smartsheets every morning and copy them to another file. We have yellow change highlights turned on but I'm finding that they can remain there for days, making it hard to see only…
-
Creating Yes/No Checkboxes in a Web Form
Hi, I'm trying to create a web form using a Smartsheet with about 30 questions in it, and I want to add in check boxes so that the user can answer a question Yes or No. However, the only way I can think to do this is to create the question as a column, and then create a seperate Yes and a seperate No column to give me the…
