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
Renewal Date
Hello - I have a column for Purchased Date and a column for Renewal Date. I want the Renewal Date to automatically populate to the following year so we know when renewal is due. What is the best formula? Thanks, Barb
Logical Update Request
I am thinking about a scenario with an automatic update request: On the task start date, send an update request to the 'assigned to' column. On task completion , send an update request to the 'assigned to' column. Looking at the new update request functionality I am wondering if anyone has thought of a way to do this.…
Detect if cell value increased or decreased
Is there a way to detect if a cell value increased or decreased compared to its previous value? I've already devised a way to reflect a symbol if the auto-column date modified was today. Now, I want that symbol to vary depending if the value on a cell in that row increased or decreased. Or if there's a way to put in two…
Formatting
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?
#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!
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…
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?
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?
