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. Discussion List
Integration With Survey Moneky?
Is there a way to export survey results from Survey Monkey directly to a SS sheet?
Sum cells in a column based on check box status?
I am currently using a SUMIF formula (which works as expected) to sum values in a column when a row contains specific text =SUMIF($[Activity]$29:$[Activity]$344, "Consultations", [FY 2016 YTD]29:[FY 2016 YTD]344) Now I want to add a check box column so I can an another clause to my SUMIF statement to sum only those rows I…
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
Earned Value Management
Please how do you calculate earned value with smartsheet? I have been looking at the videos but yet to find an answer.
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",…