-
How do I not report on parent row tasks from a project plan?
I created a project plan where I created (for example) a parent row of "Day 1 Comms", and then created 2 children rows ("Develop comms" and "Approval of comms"). I assigned the 2 children row tasks to "Marketing" and added start and end dates that were in the past. I created a report to see all "overdue tasks by dept"…
-
Calendar Time (Hour/Minutes)?
Good Afternoon SmartSheet, Does SmartSheet support Hours / Minutes within Calendars? The reason I am asking.. I have both a PTO and Scheduling sheets right now that currently have a Calendar setup on them where people can request a date to work/off from work. However it shows them for the entire day. But, I also have Part…
-
Is there a way to crate a custom sort order on reports?
I have a report that includes a "Priority" column (single select - Critical, High, Medium, or Low). When I use the sorting function in the sheet, I think it sorts in the order of the list that I typed in the column properties. However, when you're in a report, the sorting only allows for ascending or descending…
-
Dependencies- Start and End Date help
I am trying to automate the start and end date of Task #2 from Task #1. I have enabled dependencies in Smartsheet. Here is the order of events- A deal closes on 9/29 (task #1/row #1), and then I need to do a knowledge transfer for 4 days from 9/30-10/3 (task #2/row #2) For example: Under the "Predecessor" column on row #2,…
-
Need help with a formula!
Hi community, I could use help with a formula. I have a sheet that has all of our Claims data (types, dates, etc) and then a separate sheet that identifies the different claim fees per type of claim. I am trying to have each claim reference the Per Claim Fees sheet to take the type of claim (Auto, Workers Comp, General…
-
Where has my automation gone?!
Hello I've inherited some sheets from a colleague. When they handed them over, there were a number of automations set up on a sheet as well as a dashboard. Today, I've viewed the sheet. There are no automations and the dashboard is asking me to add my first widget. Where has it all gone?! I've tried the Activity log for…
-
How can I use a calculated duration that uses my own formula?
I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?
-
2024 Calendar template
I'm new to Smartsheets Has anyone created a 2024 Calendar template for their company dashboard that they are posting multiple daily events with the starting time? Willing to share the template?
-
Copy Sheet Name Hyperlinks to Another Sheet
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
-
Shortcut Widget for Folders
Help! I am trying to build out a dashboard with a Shortcut Widget to multiple project folders that hold different sheets. I don't want to link directly to the sheets, more so, I would like the shortcut to direct the user to the project folder. Whenever I click on the folder icon in the Widget, nothing populates! I've done…
