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…
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 ema…
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-…
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 t…
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…
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 try…
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 me…
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?
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 plotte…
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 t…