-
Visibility on Form Submission
Is there a way to increase visibility for requestors on their submitted requests? Like is it possible to send the requestors all of the requests they've submitted so they can see what they've requested, date, description, etc.
-
Merged: add Spell Check
This discussion has been merged.
-
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…
