-
Update Project Status Automatically from Gantt Chart
I am currently using Smartsheet to create a Gantt chart for each project as well as a table to keep track of project status'. I would really like to have the Gantt chart automatically update the project status so I don't have to do everything twice.
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
-
How do I combine multiple INDEX Collect formulas in one Formular?
Hello, dear support team, I have a question about combining several Index Collect functions. The Goal is: I want to get the Payment Terms into the Cash Out section of the Cashflow. As you can see in the picture below; 25% of Product #1 has to be paid in the calendar week 8. 50% of P#1 in CW9 and the remaining 25% in CW10.…
-
Color of Progress Bar in Report in Gantt View
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else seen/experienced this?
-
Need report and forms to track client status
Working on a project with about 680 customers managed by 8 customer success managers. I need to track each customer's status throughout the project (will run through the year) with about 5 milestones. I'd also like to have a form so the CSMs can easily update the client's status after speaking with them, and a dashboard or…
-
Create a template set with linked cells
I use two sheets to track one project. I use these same two sheets for many projects. One is a fully detailed list of every task's status, assigned to, and start/due dates, and the other is an abbreviated version that only contains specific tasks for a person(s) that is assigned to the project. Every cell in the…
-
How to find the Nth weekday of a given month?
I'm working on a formula that will provide the date of the 3rd Thursday of the month. That much I have working, but am trying to modify it to work for any weekday of any month. As of now the first and last weeks of the month are causing issues (returning a date from previous month, returning a date in the next week, etc.).…
-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…
-
Project-based timesheet approval + automatically add team members to a project
Issue: For a Project-based timesheet approval flow it is necessary to add the team members to a project. A Project Owner needs to add someone to the project first to be able to see their time submission. Booking someone for a project for the first time, would make this person a team member. However, RM isn't handling this…