-
Column misalignment
I have had this issue on and off for a few weeks. After using toolbar to make changes to sheet the columns dont line up with the header descriptions. Anyone else having the same issue? Regards Wayne
-
Leading zeroes won't populate
We have a sheet with a column for zip code and the type of column is Text/Number. However, if the zip code starts with a "0" it won't show the leading zero. Thus we end up with an incorrect zip code entered. I'm sure it's an easy fix, but I"m stumped. Blessings, Loann
-
Please Help
Hi, Smartsheet friends. I am new to Smartsheet and am still trying to find my way around. Is it possible to calculate a formula on one sheet that references data on a separate sheet, like you can in Excel? I have a master sheet that includes all my data. I tried to summarize the data using various calculations at the…
-
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
-
Post Trial Review of Smartsheet as an IT Project Management solution
I've been assessing Smartsheet as a viable replacement for MS Project at our office over the last 30 days and I thought I'd share my finding with the Smartsheet community in case somebody else is also doing such a review. I'd also invite Smartsheet to respond to my observations if they feel I've misrepresented anything…
-
Milestone task child in a % complete parent roll up
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
-
Highlight changes function keep on disabling
Good day, My highligt changes function keeps on disabling. Any recommendations on how to fix this? Thank you, Y
-
"Saving as new" options doesn't roll forward alerts
I have several month-end sheets that I rollforward each month and the "save as new" option allows to keep data/formatting, attachments, discussions, and forms but not notifications/reminders. I have several alerts set up throughout multiple sheets. When I roll the sheets forward with "save as new" I have to then set up all…
-
Save document with dismissed filter
I have my document saved with an applied filter. Now I cannot save it with the same filter dismissed. I can only change the filter and the change is saved. When I dismiss the filter and do save and re-open the document I have the last saved filter applied. Is it a bug or a feature? I have a workaround of "Select All"…
-
Link to another sheet with Function
Hello, i'm newbie for using smartsheet, May I know how make a link to another sheet using Function? Example: I'm created 3 Sheet 1. Sheet A --> Column Volume 1 = 30 2. Sheet B --> Column Volume 1 = 20 3. Sheet C --> Column Volume 1 is SUM of Sheet A Volume 1 + SUM of Sheet B Volume 1 How make do that, need your advise,…