Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for August 2016
Discussion List
Automating the Formatting of Cell Hierarchy
Is there a way to automate the formating of your parent and child rows? If I have 4 layers of heiarchy (h1 > h2 > h3 > h4), is there a way smartsheet can automatically formate each layer of heiarchy? For instance, telling smartsheet to make the top parent rows (h1) BOLD at 16pt font while making all h4 child rows…
Formula help: IF AND (drop down list in column and date column)
I need help with a formula. I have 2 columns I need to test true for. I would like that column to indicate Red, Yellow, or Green in the "Health Column". I need the "SCAA Stage 1 Completed Date" column and the "Content" columns to work together. One is a list and one is a date. I would like logically if SCAA column is a…
Docusign & Smartsheets
I have a workflow that I have deleted 20 times and it won't go away. I created another it shows up al the only one but when I go to send it it is the one I have deleted. Maybe I have to get rid of my Docusign a/c and start over. I want this to work but maybe the labs aren't that good. Maybe Docusign is a bad product. Maybe…
new cards position top/bottom
Is it possible to make new lines appear at the TOP of the lane in cardview?
Calculate Total Time Spent Filling out a Webform.
Thank you all in advance! i was hoping to capture 2 time stamps from a webform automatically. Idealy the webform would capture the time the user started filling in the first field on the webform and then capture the time the webform was completed/submitted. Idealy, the solution should not involve the user entering a time…
date range formulas
Can anyone help me please with the below formula. it all works fine except the date section at the end. what i am trying to achieve is a condition that captures entries that fall between 2 dates in the past. eg last 60 days and last 30 days =SUMIFS([Actual Hours]43:[Actual Hours]602, Status43:Status602, "Complete",…
Proxy owner
We currently have one license owned by a top-level manager. This manager does not have the time to create sheets for every project or every user but also does not want to transfer the license as she wants access to all the sheets created. Is there a way to have a "proxy" owner of the account? Someone who can do the…
OpenAir Plugin?
Is there a plugin to OpenAir? https://www.openair.com/index.pl
Forward Email
Is there a way I can forward an email to Smartsheet and start a new line item? Even better, is there a way to integrate an email back/forth into updating into the comments of a SS line item? Trying to find a way to keep track of emails via SS. Maybe there is an upcomming integration with Front App or someother email…
Sights Help
I would like to add a widget in sights like the "Complete" widget in this example. I can bring in the number and % in a report, but how can I bring in the symbol and definition? Thank you!
