-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
Count Number of Open Items in the Last Month by Day
I am trying to make a chart showing the number of open items each day in the last month. In the last month will be flexible so this will be a item that autopopulates the chart as the month goes on. I have a column for the formula =TODAY(-1), =TODAY(-2), etc. to populate the dates for the last 30 days. I have a "received"…
-
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.
