-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
-
More column types?
Any chance we will see additional column formatting to include things like Currency and Phone number formatting?
-
Linking sheets using filters
HI, Newbie here, so forgive my mistakes. I have 2 teams with their own smartsheets in their own workspaces. We are trying to cross link the data. 1 team has its data in the format of each specific product has its own sheet and part of that sheet is a reference to which partners are involved with that product. The partner…
-
Formula to highlight a cell
What would the formula be if I want a cell to be highlighted in a particular color depending on the entry in another column. Example: If column A has the word "Light" in it then column D is highlighted yellow. Thanks!
-
Formula Help
So I need some help with a forumla, not sure if its possible or not. New to smart sheets as well so im hoping for some guidance. I have a Sales Pipeline document that ive created to track all projects in the sales pipline with summary info at the top of the page on how many jobs are in each stage of the process and the $…
-
Cell value if there is an attachment?
I would like to add a cell that will show certain text if there is an attachment to each row, is this possible?
-
Scheduled Dates
I am a Project Manager working on a project plan for a technology company. I estimate dates based on the initial project kick-off date. I allow a certain amount of days for each process step. Example: - Kick-Off Date = 01/01/2017 - Estimated Development Start Date =[Kick-Off Date] + 7 = 01/08/2017 - Estimated Development…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Want to track when actual completion date is greater than planned due date
I have set up a column to track the actual task completion date. I'm trying to set up a flag/conditional format where I can quickly see when tasks have been completed later than planned. I can't seem to set up a conditional format formula in the "Completion Date" column. How would you do this? Thanks