-
PMO Template - Issues with Project Intake Form --> Project Intake Sheet
Hello All! I wanted to see if someone could assist me with fixing a bug I created. I was using the Project Management Office (PMO) template set and the 'Project Intake Form' and 'Project Intake Sheet' - the connectivity between the two (aka when I use and fill in the form, press submit, it would generate a new Project ID…
-
Creating a Booking System with a Time Component
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…
-
Simple Automation Not Working
Hi Everyone, I have set up the following automation: Unfortunately, the automation does not appear to be working: I've saved the sheet and refreshed the page multiple times. Can someone help me troubleshoot? I have a very similar automation set up on a similar sheet, and it's working just fine.
-
How to view your roadmap in Smartsheet
Hi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadmap (see image attached). Do i need to change my setting in smartsheet to view my roadmap? I can only see it as the Gantt…
-
Health of Work/Color Formula Question
Hello, I am new to Smartsheet and have no idea on how to properly articulate the following rules in a formula. I am using the colors RYGB and following statuses: • New = green, if end date is one week away yellow, If end date has passed red • In progress = if % complete is between 80-90% and not overdue green, otherwise…
-
Email content into a sheet
Box has a great feature where you can send an email to a specific box email account, and it will automatically put the attachments into the folder associated with it. It would be great if we could email a designated smartsheet email, and have it automatically add a line to a sheet with the attachment or content included.…
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
How do I search for duplicate data within a sheet?
Hello everyone! I am very new to Smartsheet and new to my position as a New Product Development Coordinator. My company utilizes Smartsheet to track new ideas for products as well as the progress of the projects done on them. We have a master sheet that all the ideas are filled into from a form showing who submitted the…
-
How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having…
-
Summary Count of Status by Assigned Person
I have been racking my brain for a bit to figure out a formula for a summary sheet that will give me a count of each status (not started, in progress, complete, at risk) by the user assigned. I am trying to pull this information from my project sheet. I have a summary count for each status but I cannot seem to add the…
