-
Conditional Statements
Hi Everyone, I would like to as add formula to the start date and finish date of the task/project like, if the duration is less than 3days, the result will "rush fee applies" like a note. And, another formula is for language services or any other; language checks box yes or no if I click on yes those languages will appear…
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Encoding for importing csv file
Hello My csv file to import contacts has accented characters and these ones are not recognized (or badly converted) when importing. I tried my file with UTF-8, UTF-8-without BOM and ANSI encoding and same result for all 3. Does anyone solved this kind of issue? If i use the same file to import new user, accented characters…
-
How do I remove erronous contacts from the All Contacts repository?
I am the Admin on our company account. I have updated the User Management and My Smartsheet Contacts with the most accurate employee list. When I am assigning out or updating tasks, there are still erroneous and duplicate contacts in the All Contacts list. How do i remove them to avoid confusion? Thanks!
-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
How to show the actual person who added information to a sheet
In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there…
-
Add a task to more contacts from your contact list
Hi, Sometimes a task is not assigned to one contact. Is it possible to add (for example) the task to two contacts? Regards, Melanie
-
Automated Notifications for Swim Lane Changes in Card View
Now that Card View has been unveiled (and I love what I see so far), is there any way to automate notifications based on status changes? For example, let's say that we are using card view for a Kanban board, with swim lanes for "Work Queue," "In Development," "In Test," and "In Production." There are different people who…
