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. Archived 2016 Posts
Archives for February 2016
Discussion List
Convert date format to mmm-yy
Does anyone know how to convert a date in dd/mm/yy format to a mmm-yy format with a formula like =TEXT([Start Date],"mmm-yy")? Thanks.
Freeze row or rows at top of sheet or column info mouse-over
Since the column header are fairly limited in max length, it would be nice to be able to add some info on the column purpose to either a row that has been frozen (does not scroll with rest of sheet), or to a mouse over field. Is there any plans for such a feature. Kind of surprised it isn't already in place. Maybe I am…
SUMIF invoice totals from the past 6 months
Hi- I have a sheet that I input invoice amounts into for multiple outside contractors. I have the name of each contractor as a parent row and their invoices as the children rows. The columns are date, invoice number, billable items, amount and code name. I want to create a formula above all parent rows that would SUMIF the…
Indented rows not showing on PDF
When I print the sheet to pdf the indented rows are collapsed on the pdf but they are not on the screen view. This is not happening with other sheets. This paritcualr sheet has: - many links to other sheets - i am not an editor Is there something else I need to do for the indented rows to display?
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?
Tracking Purchasing Approval
We are trying to find a way to track our purchasing process. I have created a sheet with a web form, but am having trouble with the approvals part of our process. Typically the purchaser would fill out the web form to request payment to a vendor or to themselves as reimbursement, then they need to get 2 approvals from…
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.
Email Notifications and Lost Data
No one in our company is receiving email notifications from SmartSheet. This started happening after the upgrade they did over the weekend. We have also lost some data from our sheets. The data was entered and then later disappeared. I've tried emailing SmartSheet about the issue, but have not received and explanation. I'm…
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…
Print and/or Publish without column and row headings?
I know that I can remove row headings when I print, but I can't find an option to remove the column headings. The same options to remove row and column headings are also needed on teh publish feature. SmartSheet provides format opportunities to make a sheet look nice, but then the column headings can really be annoying. Is…
