- Link to a cell in the comments
Hi, Is it possible to paste a cell link in a comment of another sheet? I have a sheet in which certain rows refer back to other rows in other sheets. I want to be able to paste that cell link in the comments for quick access. Y
- MS Project 2016
Hi All, I've just updated to MS Project 2016 and am unable to import my programmes into Smartsheet. The tasks import ok, but the duration of every task is at zero days. Urgent advice would be greatly appreciated please. Alan
- When a Web form entry adds a new row to a existing sheet how can you set up that the columns are in
Hello hop I can get some help we have a sheet we track expenses of field projects that has a basic Sum fuction to add of total cost then links out to a nother sheet for tracking the budject vs actual if I use a web form it creates a new row my question how do I get that new row to be adumaticly add the the colom sum…
- 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
- 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
- Extracting a Date from a Text String into a Date Column
I have data sent from my CRM into Smartsheet. The CRM will only export an appointment date and time together as one cell, formatted as: 2/09/2016 8:00:00 AM. I need the date to be in a separate column for filtering and formatting purposes. I've used a MID function to separate the date from the time using this formula:…
- 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
我想建立一个工具库存,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…
- Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
