-
Links with Logic
I have two sheets that I want to share information across. Sheet1 contains hundreds of part number records and standard data fields required for each part number. Sheet2 contains essentially a task list of needs to be addressed each of the part numbers on Sheet1. The amount of tasks per part number is highly variable and…
-
Client list in card view
Hi guys, we've been using smartsheet for about a month now. We have our client list set up in card view which is taken from my smartsheet contacts. If you hover the mouse over the contact it only shows their name and email address. Is there anyway this can come up with their phone number too? We have phone numbers set up…
-
Alerts/Notifications based on cell color
I would like to create an alert. If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
-
Formatting with alerts
I need to do the combination of formatting with and alert, but seem to have hit a wall. If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red and send an alert to the contact in columns "PM" and a particular individual. Any help would be appreciated.
-
One Task with multiple Predecessors
Hello, New to SmartSheet. Question is, I am working backwards, and i have one Task (Task 3) with four Predecessors. These four Predecessors end up having different Start dates. Task 3 ends up having an End date of the Predecessor with the shortest Duration. Shouldn't Task 3 have an End date of the Predecessor with the…
-
Update Request for Specific User
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these change as a project moves along. I have several people outside my organization where update requests work perfect for them…
-
Auto numbering each line
1. Is it possible to assign the values of the number in each new line with a given step (or digit number) For example: 005 010 015 020 025 etc. 2. If I need to insert a new line between 010 and 015, I would like to be able to recalculate all subsequent rows in accordance with clause 1. And the second option is to set the…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Conditional formatting if task is behind schedule
Hi guys, I'm new to Smartsheet so forgive me to ask the question. How do I setup conditional formatting to a task that is behind schedule? I created 2 lines of conditional formatting already: 1 ) task is 100% complete -> green row 2) end date is in the past and % complete is not 100% -> red row I'd like to add a third…
-
Smartsheet Experts
Hello I have been supporting a company in implementing Smartsheet. Successfully :) Today, I'm getting more and more involved in various other important projects and as a result need extra competent workforce to help me supporting our teams. Any interest? Raoul.