Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Alternative to VLOOKUP in SmartSheet?
Is there a 'bolt-on' in Smartsheet that does the same thing as VLOOKUP?
Card View - Re-Order Sub-tasks
Is it possible to reorder sub-tasks within Card View? Instead of needing to go into sheet view to reorder the sub-tasks? Would be more convenient to stay within Card View to reorder sub-tasks rather than needing to switch to sheet view.
Is there a way to view a map created using Smartsheet labs in the Sight view?
I created a map from one of my sheets and I want to display it on my sight/dashboard but not sure I can do this. I know I could add an image and then edit the interaction to view the map but thought I would ask. Thanks!
Quickly edit linked cells
Enhancement Request: The ability to edit cells linked from another sheet - either directly or by double clicking and being able to edit the original sheet in a pop-up. I have a master sheet with all of our project level data on it and engineers have individual sheets for their projects which allows them to add any kind of…
Confused by users and resources
I'm pretty new to SS, which I've been added to by my project's owner as their preferred tool. We have set up a high-level schedule with gantt chart to get a top-level idea on estimates. I've assigned tasks to people (adding them as needed) and got a pretty gantt with a critical path, but have no idea how utilised each…
Cell linking within a sheet
Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, Paul
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
Wanting to count dates within a column
Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column. Thoughts? Thanks! Shannon
Auto populate data in other columns by selecting dropdown value in primary column
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item. Can this be…
Control and/or Burndown Charts
I have not been able to find information on how to create a control and/or burndown chart in Smartsheet to track the cycle time of tasks as they pass through different statuses and the remaining work. I was planning to add columns and create formulas to track the dates when the status changes and then create reports to…