-
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…
-
Find First Duplicate in a Sheet
I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
-
Teamwork and Smartsheet Integrations (Zapier?)
We currently use Teamwork for project management. Our account managers update their milestone dates in Teamwork to create their job schedules at the beginning of a project and then adjust the dates as it progresses. Our organization-wide job board is kept in Smartsheet and we run several reports from it (including monthly…
