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
Alerts when nothing changes
I know I can track/highlight changes and I know that I can set up an alert when something changes. However, is it possible to get an email alert when nothing changes? For example. If I was expecting a task to be completed on March 1st and the task owner did not update the status field on the project plan, can I get an…
Date problem
how can i change the date display in Chinese to US?
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
Trouble importing from MS Project
I get a master schedule in a XML file and the basic info all imports fine. There is another data field which won't import for some reason. It is a text field with essentially "assigned to" info. Any suggestions? thanks Bill
Add Card appears in Row 1039 - each and every time - any idea how to fix the bug - thanks
Add card appears in Row 1039 in Grid View - I only have 55 Rows occupied with fields - i've deleted , refreshed, but makes no difference. Each time Add Card appears in Row 1039 - any idea how to fix the bug - many thanks
Date-based RYGB balls automation
Hi, For the past couple of days, I have been trying to automate my RYGB balls based on Target End Date and Actual End Date columns. I've been reading this article, but I cannot seem to get the formula right. These are the conditions I am trying to satisfy: * BLUE = if the Target End Date cell and Actual End Date cell are…
How do I create the Annual Manager Evaluation Form?
It can be found at this link: https://www.smartsheet.com/free-employee-performance-review-templates I've searched through Templates and don't see it.
conditional notifications
I would like to know how can I do conditional notifications on my sheet? I would like to create notification when someone change any column other than (Owner / Assigned) will send out notification to that row (owner / assigned) instead of every user.
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
Outlook 365 Integration
I'm running Office 365 and within my desktop Outlook I have highlighted an email that I want to attach to a row in Smartsheets. I have the icon in Outlook "Add to Smartsheet". I open that icon within Outlook and I search for the Smartsheet. I navigate to the appropriate row and I can view all of the columns & data in that…
