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.
I have added conditional formatting to my rows but when I switch to the calendar view the color is not being adopted. I have looked through the webinars but could not find anything.
Use Smartsheet row data to populate a Template
I am looking for a way to automate a process to take data from a single row in Smartsheet and populate a template. Working in the construction industry, processes are slow to change and we still need to PDF documents for communication with our customers (RFI's, Change Orders, etc). I have setup the forms and procedures for…
Open Default E-Mail App When Clicking Cell w/E-Mail Address
Does the functionality exist to be able to compose an email with the click of a button (activates default email app on local machine) from a cell in Smartsheet that contains an email address?
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!
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…
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?
How Do I Prevent Spam Entries On My Web Form?
I see no option for Captcha or Honeypot to prevent SPAM bots from attacking my form, which is currently being bombarded by fake Chinese entries. How do I implement this?
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…
Gantt Chart Display
Does anyone know if there is a way to display the children (multiple) under a single parent in the Gantt Chart? I have a chart with several children per parent and would like to display them all under their respective parent. Each child has a set of start and end dates; the end of one child is not the start of the next…
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?…