-
Merged: Merge data from 2 sheets into 1 row
This discussion has been merged.
-
Project Manager Count
Hello - I'm trying to build out a dashboard where I include a chart containing the project manager and the count of projects they currently have utilizing the PMO workspace. With some of our projects being large, we've allowed for multiple PMs to be on 1 project. Is there a way to modify the COUNTIFS to account for a name…
-
"Review status" based on multiple checkboxes
Hello! I need help trying to figure out formulas that triggers the review status to green or red based on how many checkboxes that represent each month of the year are checked off. The boxes that are checked off would be based off on the frequency column which is semi-annually, annually, bi-weekly, daily, quarterly,…
-
Is an automated export of a Smartsheet to an Excel file possible?
Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.
-
Hidden or Blind Comment Feature
I would love the ability to have a hidden or blind comment feature for end-users to provide comments or feedback without being able to see the comments posted by other people. This would be especially important for intake sheets so the committee members can have conversations about the request in the comments section and…
-
Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Dashboard Gantt Chart - Visualizing Variances
Hi ! My Dashboards are meant to visualize high level information on my portfolio of projects. One key is visualizing the project duration on a Gantt Chart from Inception to Completion (Project Start to Project Finish Date), which shows as a single bar connecting the two dates. However, the Gantt Chart in the dashboard is…
