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 2017 Posts
Archives for October 2017
Discussion List
How do I populate one field fromt he results of another
Hi there I am trying to create a purchase order system to work with our Programme manager (which is all in Smartsheet) Currently we use excel to create a purchase order then print it as a PDF. We then combine the PO with a quote from the supplier in Nitro. What I am looking for is a way to use smartsheet such that we have…
#UNPARSEABLE
I am using the following formula to calculate the net days but only if the dates are listed. What am I doing wrong? =IF(AND(ISDATE([Date Received]3085), ISDATE([Processing End Date]3085)), NETDAYS([Date Received]3085, [Processing End Date]3085), "") Thank you much!
Jira Connector End Date one way???
I have set up our jira connector to send an end date over to smartsheet. however, if I enable dependencies, the connector changes this to a single direction from smartsheet to Jira. This has changed a load of dates in jira that i didn't want it too! Why does it do this? and does anyone have a handkerchief i can cry into?
Day or month as 2 digits
Hi all - I want to use the day and month of people's birthdates to create user IDs. I can extract the month easily enough, but I want all of these to be 2 digits (ie. if it's June, I can extract '6' but I want '06'). Does anyone know how to get a 2 digit month? Thanks
symbol column to add workdays in formula
Hi, I want to create a RYG status if a date is late. If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green". The End Date is the due date. The underlined formula will show 2 calendar days but I need workdays/vacation included. Any ideas on how to resolve?…
How to push fields closer together or hide label field in webform?
We've created a webform which has a couple of multiple selection questions. We used the make them all from check boxes field types with the label to the right but we want an additional field below for free typing feedback. The problem is the free type field at the end of the list is it looks out of place having a label of…
Webform Linking
I have a main webform for clients to enter project initiation info. There are a few different types of projects and forms for these projects. Is there a way to link a webform selection to another webform?
Formula to ammend task descriptions in a project
I hope I can describe this... I work for a video production company and I create individual projects for each video project we have going. There are general task descriptions I use in the Primary column and I would like to have the actual Client Name -actual Project Name follow at the end of every Task description. Is…
Colouring Cells using a formula.
Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4baead18e6d0a76e4 Overall Rating Score 4.6 - 5.0 (Green) 3.6 - 4.5 (Light Green) 2.6 - 3.5 (Yellow) 2.0 - 2.5 (Light Red) <2…
Convention planning template for multiple presenters / tours each day x 1 week
Hello! I'm a newbie and have been searching for quite a while in and out of Smartsheet for a template or method on how to use SmartSheet to assist with planning a weeklong convention. The part I'm missing / stuck on is the actual events during the convention, e.g. 6 to 8 clinic rooms running simultaneously with an equal…