-
Spred Sheet for each Department
Hi there Everyone I am new with smart sheet and i work on a Engineer firm. I am encharged of the design department and i was wandering if it would be wise to make a sheet ony to this department. Or making a sheet to work with all departments at the same time. If someone can help me with this! thanks!
-
Linking in the Same Sheet
For large sheets, is there a way to link from rows to other rows within the same sheet. For example, I have developed a lirbary of sorts with files that fall into different categories. There are several categories and lots of files in each category. I was thinking I could have each of the categories at the top of the sheet…
-
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…