-
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…
-
Meeting Minutes In Project Plan
Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank meeting minutes form for a call, complete that form, and archive those minutes still in that specific subsection of the…
-
Notification Email Background Color
My notification emails are now coming across with a colored background. Is there a way to turn this off in SmartSheet so that I don't have to do it when I forward my emails?
-
Add more than one column data to chart (x,y scatter)
Hello, I am trying to generate a chart from a report that contains three columns. The first is the subject (label), the second the day (time to be plotted on the x axis) and the quantity (to be plotted on the y-axis). Since I am plotting from a report, I don't want to reformat the x data to columns as other posts have…
-
3 Month Compliance Tracking
Hello SS Community! I've read lots of answers over time but never asked my own question so here goes nothing! I need to create a tracker for individual employee Compliance for training. We have many tests that each employee performs, but they must stay compliant within 3 months. They can't go 3 months without doing one…
