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.
Discussion List
Auto numbering rows
My first row is listed as 2 and not 1. Did I need to make the starting number as 0 (zero) and not one as assumed?
Removing the "d" from the end of a numerical calculation
Is it possible to remove the "d" from the auto calculated columns? For example I have an open date and close date and I want to know how many days it took to close that item.. when it auto calculates that item it adds a "d" at the end of the number. When I export the file to excel to review the data I have to manually…
Mark parent row at risk if any child row is at risk?
This would seem to be a "project settings" sort of thing, but i can't find it. Is there a formula that can accomplish this?
Protecting Smartsheet
I have several sheets starting with same first word as name and always delete wrong sheets due to oversight and undelete to get it back, whenever I bring it back, it loses the formatting i.e. size of columns and sharing. Right now, check and delete, sheet is gone. Is there a way that I can set warning or some protection to…
PayPal
Is it possible to use a PayPal button to submit Web-form?
Issues viewing Live Webinars
Hi all, I have been having issues viewing live webinars since the switch to the "GoToWebinar" format. I click the "join webinar" link that I receive via email and am brought to the webinar landing page. I can hear the audio (in real time) perfectly but my screen never refreshes so I miss out on the visual examples being…
Consolidating project costs
How can I add the total cost of four projects that are detailed on four sheets to one cell in a master sheet? It seems you can only link a cell to a cell, not a cell to four cells to add them.
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…
Automatically Sum rows that have the same value in a specific column.
I would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in…
Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
