- Printing All Comments by Sheet
Hello! Is there a way to print all the comments contained in a sheet? Right now, all I can see is the option to print them row by row. Thank you, Sandy
- Formula to display when a task is late based on start date and status/% complete
I'm looking to develop a formula that will visually (either text or symbol) show when a task is overdue based on a Start Date and the, either, status or % complete. I've tried to combine the RGY or the Harvey ball but that is using only one parameter and I need both columns. Thanks in advance community!
- =IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
- 过滤器卡阶段/父母的头衔
Is there a way in the Card View to filter and only see cards within a certain phase or cards that have the same 'Title of Parent'? I have a multi-phase project with hundreds of total lines and it would be great to be able to break up the cards to only focus on the current phase of the project. I'm also open to any other…
- Automated task status in a project plan
I am building a project plan and would like to have the "Status" to be automated based on the % a team member fills in for a task. I've tried several of the IF OR and IFAND statements and they work partly. I can get the "Complete" and the "Not Started" to work but unable to figure out the "In Progress". When I try to nest…
- 年代IGHT Metrics
I am part of a PMO and we track all projects on one sheet. The PMO covers multiple lines of business within our organization, thus I have a Sight set up per line of business. In each Sight, I would like to be able to show the number of projects in each RYG status. What is your recommended approach for doing this? I've been…
- Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
- Project Resource View
Hi: I'm looking for a way to where the Project Resource View will list actual Task Names against each resource in my project sheet instead of the smartsheet file name against each person. . Is there a way the Project Resource View can be tailored and utilised as a resource management tool?
- 年代ights: Sheet Name Link issue
I am having an issue with my Sights where I have a Report Widget and within the report is the "Sheet Name" link. From the Sight, the first time I open, the Sheet Name link does not work. I have to first click in any other column to open the Report, and then the Sheet Name link will take me to the row on the Sheet. I can…
- 年代um of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
