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
Card View - Re-Order Sub-tasks
Is it possible to reorder sub-tasks within Card View? Instead of needing to go into sheet view to reorder the sub-tasks? Would be more convenient to stay within Card View to reorder sub-tasks rather than needing to switch to sheet view.
Nested IF Statement for Flagging Duplicates
Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff Smith Programmer Jeff Smith Designer Jeff Smith Designer In this scenario, I want a flag checked off when ALL 3 appearā¦
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?
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ā¦
Nested If Statement
I have been struggling for a long time trying to get a formula to work for me. Here's the issue... I have two IF statements that work fine independently of each other, but when I combine them I keep getting an 'incorrect argument set' error. Here is the formula, and if someone could help me out with this I would be veryā¦
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?
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ā¦