-
Merged: Favorites List Sort/Display Order
This discussion has been merged.
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
How to add an Image into a cell in a Report
We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and only shows columns relevant to that step/user. My question: You can copy/paste an image…
-
How do I fix corrupt Level Code and WBS Phase
I somehow caused an error in my Smartsheet and now both Level Code and WBS Phase have 'UNPARSEABLE' in every cell. How do I fix this?
-
Expiry for Update/Approval Requests - Automation
The ability to have update/approval requests expire and become inaccessible after a certain date. An expiry date will also allow for the automation of reminder of request. There are times when an update/approval is needed to reach a deadline. The sheet user must manually delete the request on the row to avoid changes. If…
-
Calculating Days
Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Sharing Two Linked Template Sheets
We are rolling out a new process dependent on two linked template sheets to be shared into workspaces for each new project. When we share the templates into a workspace today, it appears to retain the links back to the original template in our template workspace. Is it possible to share two templates together and have them…
-
"Project Requirements Matrix" excel Template
I am trying to import a excel template into Smartsheet but when I do the formulas are all out of sync. The template was on the Smartsheet website but whenever I click on the "Click here to Create in Smartsheet" it asks me to sign up for an account. Manually uploading it just makes it very cumbersome due to the formulas…
-
Maps
Please consider building mapping tools. For example, it would be nice to be able to generate a simple map showing the location of facilities we service across the states in our region. That map could be displayed on the company dashboard. More complex mapping features would be useful to incorporate with scheduling clinic…
-
Tracking Projects on Smartsheet
Hi, I currently have a list of projects that i'm tracking on a smartsheet, However if I were to add milestones/tasks, I’m unable to merge the rows under column “Project Name”, “Project Manager” thus having multiple rows with repeated Project names etc. How do I go about setting this up all in 1 smartsheet? As ideally I…
