-
What to do when project ends?
Hi Smartsheet Community, Our company works with customers on projects for a set period of time. When a project is complete, we archive completed projects for internal use, but we no longer need our customers to view or edit sheets and sights in Smartsheet. When a project ends, is there is way to inactivate or close our…
-
Formulas
I would like to add a line and keep the formulas of the previous lines, is it possible?
-
Add a comment to the column
Hello, I'm wondering if I add a comment to the each column? like description. I would like to add some description to each column title when users drag. I usually use a lot of abbreviation on the column title. I want users to easily know what does the column title means. I tried to find the way. However, I couldn't find it…
-
if-then-else logical function
I have a symbol column valued ( green, yellow,red). I want to set the color based on a logical formula as follows: There is Start and a Finish date columns. if ((Start <= Finish - 8, "Green"), IF(AND(Start > Finish - 8 , Start <= Finish), "Yellow"), IF(Start > Finish, "Red") Anyone, can you correct this? Thanks Art
-
User access to drop down menu
I have added a new user with "Editor-can share" credentials. He is unable to fully acces all the fields in the drop down menu, the box marked filter is ommitted on his sheet. Also the message "23 days left" is beside the upgrade button, no other user has that message on their sheets.
-
Google Calendar creating two events for every task
When integrating my Smartsheet into Google Calendar it creates a second event for every task labeled "Edit Smartsheet Rows". I think this has something to do with making it easier to adjust the Smartsheet from the Google Calendar, but I don't need that functionality nearly as much as I need my team's calendars to have the…
-
Small Business people out there?
Hey, Just starting with Smart Sheet I am looking for anyone who manages a small business with lots of tasks for some tips on better time management
-
long numbers are rounding up the last number
My long numbers are rounding up the last number. These are whole numbers. How do I stop them from rounding? The numbers are 16 digits long. When we copy them from any source, they round up. Since these are customer numbers, you can imagine that is a big problem.
-
Mysterious row sorting - unable to pinpoint issue
I've noticed on occasion that rows within some of our team's sheets will appear in a random location within the sheet. When I check the activity log, I see points where certain collaborators have "reordered rows", but I'm unable to determine if that means it was done through sorting or filtering, etc. Plus, no one on the…
-
Name instead email on System/Created By column
Hi, Any suggestion how I can have the name instead email when I have a System column and choose "create by" option from my contact list? Thanks. Al