-
Dashboard Chart [Range Feature], Sheet Helper Column [Trend] and Quick Folder Navigation
Hi everyone, I have noticed there are a lot of features that have been discussed in the past, however they have not been implemented yet, not sure why because they would make life easier. 1st- Implement a feature within Dashboards so that we can resize the range of our charts without having to manipulate the data, coloring…
-
Error message: Something went wrong with Resource Management...
Hi, While updating one of our sheets, my supervisor and I continue to receive this error message: "Something went wrong with Resource Management. Please make an update to your sheet and save the changes to try syncing again." Connecting Resource Management to a new sheet has no issues. I am online with a good connection,…
-
Seeking Guidance on Connecting Biweekly Status Reports to Projects and Dashboard Creation
Hey Smartsheet Community! I hope you're all doing well. I'm currently working on optimizing our project management process using Smartsheet and could really use some guidance. Objective: I work for a PMO for state government. We're managing project updates through a biweekly (due every other week) "Status Report" form and…
-
Issues with DDUpdate?
Hi SS Community, Are any of you out there using ddupdate.com to support populating your dropdowns from a column in another sheet? Several people in my org are having trouble getting our payments to go through and are hearing nothing from the site. Is this just us or is it a wider problem with ddupdate?
-
Automation: lock row if attachments are present
I'd like to be able to build an automation to lock a row if attachments are present. How can I make this happen?
-
Sheets have Data Validation functionality?
Do Smartsheet Sheets have Data Validation functionality like Excel? I'm looking to preserve the order-of-operations and to ensure my automation triggers after users fill out 2 drop down cells, a text/number cell, and a checkbox cell. (The automation moves a row to an archive sheet, once the four cells are no longer blank.)…
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
Best Practice for Capturing Project Info on PM project plan
My team is using the Project Management Office template set. I love the template set but I saw this Project Information section on a different project template and I like the idea. I added it to the Project Plan template in our PMO, but I can't figure out how to use it or if there's a better way to capture this…
-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…
-
Comparing values from different sheets in excel
Hi, I've been searching for an answer to my question almost the entire day but can't seem to get it right, so hopefully Smartsheet can be my savior here 🙏 So I have Sheet1 in Excel with two columns, both with texts in it. Each row has a different word in it: column A, row 1=text1, column B, row 1=bananas, column A, row 2=…