-
How to track external dependencies
I am building a project that has external dependency to be delivered on a specific date . How do you create this dependency? Do you create a task with no duration? (start and finish date are same)?
-
Edit Predecessor Form will not appear in the Predecessor column
I am trying to add lag time to a project but when I hover the mouse in any cell in the Predecessors column nothing happens. The Edit Predecessors form does not appear. Please help, I've tried everything. "To make changes to the relationships between dependents and their predecessors, click Edit Predecessors (hover the…
-
Cannot Remove Hyper Link on Phone Number?
Please Help, For the life of me I cannot remove a hyper link. I added a simple telephone number and it show as a link (blue with underline) I want to remove this as it not a link, just a number. I tried all methods that would normally remove this. i.e right click on cell (no remove) Ctrl C - Ctrl V (even special paste…
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
-
Predicting a Date based on what type in as I complete a step
The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier.…
-
RESOLVED: Show / Search Community for unanswered threads
I would like the ability to search or show the Community Posts that have no answers. If I skim through the new posts from the past week or so, there are several that no one has responded to yet, despite several very active and helpful Community Members. If there is a way to do this already (like a reverse most-popular),…
-
Employee Objective and Performance Reviews
I am looking for a real-world example of someone using the employee Objective and Performance Review Template for an IT manager? Do you find it useful and easy to use for managing your managers? Anything you can share would be greatly appreciated.
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
