-
Managing Alerts & Reminders
Recently there have been a lot of changes to managing alerts. They have been very good changes. However, today I noticed that I did not receive an alert that normally would come to me. Upon checking I discovered that menus have changed. There is a new heading called "Automation". This took me a while to figure out. I…
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working on building a quotes log where we input a project name in Job Name which then auto fills to the Job Name Master. Next to the Job Name Master…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
Percentages
Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%. Thank you
-
Remaining Budget
Good evening: I have broken down my Project Budget and spent a total of 13% of my Budget. I have used the formula to get the total sum (13%). However, I am challenged with adding to the formula to get the remaining budget of 87%. Sum Formula: =SUM(CHILDREN()) Task A: 10% Task B: 1% Task C: 2% Task D: 0% Thanks for the help…
-
Displaying a date in a non-date column
I am trying to display the earliest date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted…
-
Alert Notifications
Hi I have set up a rule so that when a specific status changes to 'Required' the person assigned to the action gets and alert. We are only receiving a Smartsheet notification not an actual email. I have checked the account settings and we are set up for email notifications - any ideas what I am doing? Rs Abbie
-
Visual Gantt with Milestones Embedded
I'm trying to add a dynamic visual Milestone gantt on a Dashboard which lists %progress. This should be dynamic so that it displays real-time updates from the detail schedule that i'm pulling the Milestones from. Any suggestions on what tools are available.
-
Two different triggers for one check box
Hello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "this OR that" kind of question. I have it programmed for one parameter, but I don't know how…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…