-
Showing a timeline (not programme) in a Dashboard
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
NEW! Timeline view
Hi Community, The all-new timeline view is here! It lets you seamlessly arrange work on a horizontal timeline and group tasks to easily track project progress, collaborate in real-time, and communicate statuses with stakeholders. Log in and switch to timeline view to: Create and share project roadmaps for easier cross-team…
-
Add RTF (rich text formatting) to Comments
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF functionality would be limited to manually entered items, not pasted items. The…
-
Clock In and Out with Lunch Time Stamps
I need help creating a formula that will calculate my employees time in and out along with their lunch break.
-
Start and End Date in RM in Projects
Im not able to figure out how to sync the start date and end to actual project plan. Currently the dates showing in RM are from Intake Sheet which is the Target Start and Target End Date which are estimated dates. This is entered initially when filling out the NPD form to start the request of a project. Once the project is…
-
Additional API endpoint for exporting Dashboards
Hi, I was wondering if there could be an API endpoint to export dashboards from smartsheet. Would be a reliable solution for the automation I am trying to create. It would be similar to going to a dashboard→clicking on file→ print.
-
Predecessor #REF Error
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…