-
multiple fomulas in one cell
Hello i'm new to the smartsheet community and wondered if anyone can help..... In one cell i need to use 2 '=RIGHT' functions and sum the answers together. is this possible? an example of the text in a cell is "tuna sandwich - £1.50". the '=RIGHT function needs to return 1.50 and the same from another column then add them…
-
User Management
Hi All, Hoping someone can help me out, I am unable to see all users in the 'user management' view. If i go into the individual sheet i can see through the permissions users which have been set up, however if i go into 'user management' to delete them i am unable to do so because i cant see them there. secondly is there…
-
Renaming a worksheet as editor
If a workspace has been shared with me and i only have editor - can share permissions can i rename a worksheet within that workspace for example: the sheet has been set up as a template with the name Campaign #1, can i then change this to reflect the actual name of the campaign ie. Christmas holidays.... ?
-
Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
-
Smart sheet as CRM
Hi there, We are in the process of a new enterprise, and really love using Smartsheet, especially the history function. I’m looking for a good CRM cloud software, were I can easily manage contacts, pipeline, promotions, billing, INV, inventory etc. I think Smartsheet is perfect for pipeline management, but I miss the…
-
Historical Report Status
I am looking to increase my efficiency when creating statistical reports. Each week, we run a report to see how our projects are tracking (red, yellow, green traffic lights) but I what I want to do is keep each weeks statistics so that I can create a historical report of these figures. At the moment, each week I need to…
-
Transfer of account
Hi all. I have a client whom I am configuring some sheets for. They would like me to invoice them for the configuration/consulting service AND the Smartsheet licence. They dont have access to a company credit card for the in-app upgrade so wish to just pay me to buy the licence for them. I know that we can change…
-
Automate Reminder to my team for sheet updates every Friday
How do I do this? T
-
Send alerts to two people using the same column?
I have set up a smartsheet where by the 'assigned to' is alerted by email when a task is due. However sometimes the 'assigned to' needs to be more than one person therfore i have to amend my columns to be 'assigned to 1' and 'assigned to 2' to ensure both people get an email alert when the taks assigned to them is due.…
-
Company administration level management of non-licensed users
We are using smartsheet to track staff resources across our projects, which only requires senior staff to be licensed users and collaborate, all other staff are listed as non-licensed users and won't ever need to use the sytstem. It would be easiest for us to have full control of their profiles as admins when they are…
