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.
Submitting multiple rows via form
I have a form where employees can track expenses. They might have multiple expenses they need to break out. Rather than submitting multiple forms, is there a way to submit multiple rows via one form? For instance, if you have a hotel expense and an airfare expense, can you submit those in one form or would you need to…
Accounting number format?
Is there a way to set the number formatting to show negative numbers in parenthesis, similar to Excel's accounting number format?
Rows being removed
I just realized that a user removed a row from the smartsheet. So I have 2 questions. #1 - Can I keep people from being able to remove a row - while still allowing them to edit information? or #2 Can I set up a notification when a row is removed - so at least I would know when it happened. Any suggestions?
Row Gap issue from Web Form entries
I have set up an estimating log, which is populated by web form, we are currently experiencing issues where certain rows of data are being populated between 2 - 20 rows below the last entry has anyone else experiencing this issue and can advise how solve the issue?
Viewer role with the ability to add discussion comments
I have given a number of my colleagues access to a worksheet with the Viewer role. However, they are unable to add comments under Discussion. Is there a way to allow them to do that?
Reports and alerts
I would like to be able to have the alerts feature added to reports, this would be beneficial so my employees can create reports and have reminders sent to them. By doing alerts on the sheet level, the alerts are on for everyone in the contact list; however, not everyone wants to be reminded or notified. Thanks
Web Forms. How to have a default attachment (file upload)?
I use Web Forms to add new rows to a Service and Repair Register. Easy! I also wish to upload a default Job Card (Word file) with each new record, efficiently and with little chance of error. Not so easy! Is it possible to add a default file to a Web Form? My users could then select the correct Web Form, and the required…
Hello, I have a project implementation worksheet set up with parent rows and sub-tasks below them. When I enter a % complete for the sub-tasks, it doesn't reflect in the parent row unless all the sub-tasks reflect 100% complete. Is there something I have to turn off/on in order for the parent row to show a true % complete?…
How do I create a cell formula that calculates a future date from another cell that has a date?
Report Column Names / Labels are not same as Smartsheet Column Names
Hi, I have noticed on reports created from the original smartsheet that the Primary Column Label and automatic numbered columns don't have the same smartsheet column name. When you pick the reporting you want to include it uses the original default titles as opposed to column titles used in the smartsheet (if you have…