-
Current work filter for tasks not Complete and Due in the next 2 days or the past
I am trying to build a filter that will be utilized to Identify Current and Past due work. I can get the filter to find all not Completed or Canceled work in the Past or the Next # of days. I cannot get it to find all taskx from 2 days in the future and older. Is there a way to add a formula when using is less than or…
-
Screen Snipping Tool
Is there any way to screen snip and have the snapshot saved as an attachment? The only way currently appears to be screen snipping and save into word and then attach or save as image and then attach that
-
Working Days - Length of Day
Hi Team I have an employee who works 8hr days Mon to Thurs. 4hrs on Fridays. IS there a way in Project Settings Working Days to change the hours for a given day Thanks in advance
-
Formula for recurring meetings
Hi, I'm currently working on a smartsheets for a project that has a number of deliverables. As part of the process for each one, they need to be reviewed in a meeting - there are meetings already set-up with the client every Wednesday and Friday which is when they will all be reviewed. Is there a way for me to create a…
-
Status of Child rows
Hi I am trying to create a Project Schedule with Budget and Variance and include an overall status using the status of the child rows. I have 1 line that is the overall project and then 4 phase lines, with around 20 tasks underneath each phase line. I want the phase lines to give an overall status of the child task rows…
-
Update requests
Hi everyone, I have built a sheet in smartsheet to track supplier performance. When there is an issue with their performance, I am wanting to send the supplier a update request in order for them to provide corrective action for problems and it to be written directly into the sheet. This works great but to provide context…
-
Same Project, Different client (COUNT Formula)
Hi Guys, Can anyone help me do a formula for the smartsheet that I am working on (please see belw attached Pic). In the table, it indicates that there is a same project with different client, different Received and Sent Dates. I would like to come up with a Count (or other possible) formula that will result to counting the…
-
Chart on Sights
Hi, I created a chart on SS labs. I want to display the chart on my project dashboard. How can I do this? Y
-
Sharing filtered information only
I want to use SS to share information with two of my supply chain who are competitors. Therefore I want to filter out the information which applies to each company, and only allow them to see this info. Is there a way to share the sheet with filters applied? or if the sheet is shared will they be able to view the entire…
-
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…