-
Auto format phone number
Good morning, I'd like to have our phone column (text) formatted so that when I input just the numbers (ex 7195555555) it would format the number as (719)555-5555. Help? Blessings, Loann
-
Help with a join formula to view two columns in calendar view
Hello! I have several projects with many rows of information per project on one master sheet. I use conditional formatting to seperate/identify projects by colour. That colour coding applies to both grid and calendar view nicely. BUT I would like to combine a project code and task name in calendar view so I do not have to…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
Dependency Workaround: Linked End Date, Not Duration
I'm linking to someone's Start Date on a project, using the relevant sheet. However, the End Dates I need to track are at the end of a long set of tasks on another sheet - only once all those tasks are completed will this person's time on the project be done. I'd like to link to the very last task this person will perform…
-
THANK YOU!!! We can now assign multiple contacts to a column!!!!
Good morning! I just received the email update from Smartsheet Engage 2018 and I. AM. THRILLED!!! We can now choose to allow multiple contacts (up to 20!) to be assigned to a row. See the article here: https://goo.gl/sTwxNZ Blessings, Loann
-
Question on multiple predecessors
Hello! When using 2 predessors for one row, smartsheet calculates the later start date. How can I manage to get the earlier start date. For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ... Kind regards Michael
-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Linking Cells and then Sorting Source Sheet
I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated…
-
Hyperlink in email notification that redirects to the relevant row
Hi there, On receiving email notification, there is a hyperlink to navigate to the sheet. In this case, user has to find the row in the relevant sheet among hundred other rows. Is there a way, where a hyperlink can directly navigate to the affected row rather than the sheet. So in case of multiple rows in email…
-
Project Dashboard Generator
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then…