-
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
-
How do you keep the zero in the zip codes that start with zero
I put in 08601 and I get 8601. I need the complete zip.
-
Saved Filters?
Is there any option to save a filter setup view. After setting a filter, if I remove all filters, I would like to be able to re-apply without going through the process again. Ideally I would like to save a numebr of combinations, similar to setting up a report. I would use reports, but I need to show the parent rows.…
-
Are Superscripts and Subscripts possible in a text field?
We have a whole document for tracking copyright information, and we need to include superscripts in those copyrights on occasion. We haven't been able to make this work so far, is there a way to allow superscripts & subscipts? Thank you!
-
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.…
-
Filtering defeats sort function. Moving row to another sheet drops attachment link and forrmulas
1. I use filtering to hide rows with status <complete>, however when the filter is set, the sorting function is defeated. To resort, I remove the filter, sort and then reapply the filter. This is awkward and wastes a lot of keystrokes if done 20x per day. Another bright idea was to archive the rows to another sheet titled…
-
"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…
-
Allowing local path to launch as a link
I want to have my Evernote links just launch the note in my local Evernote for Windows instead of first launching it in the web-based version of the note and then in Evernote for Windows like it does. The web-based Evernote note window it launches is useless, goes unused, blocks my SmartSheet window, and has to be closed…
-
Can you sync Google Calendar to Smartsheet
Heard that Smartsheet can sync with outlook to send notifications of tasks due and add to Outlook Calendar. Is there a way to sync Smartsheet with Google Calendar?
-
Getting notifications on certain rows not all rows
Hi, Is there a way in which i can get notifications on updates to rows which have a specific criteria in and not all rows. Essentailly what i am lookng for is something similar to the below; If a row contains SH in a specific collumn, i would want to receive a notification on it. However, if the same collumn has DS i dont…
