-
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!…
-
Multiple section in a dropdown list?
Hi, Is there a way to select multiple items in a dropdown list? Here is the scenario i am trying to solve for. A product roadmap project may can be related to multiple products. I currently have a dropdown list column for products and each row is project. Currently i can only select one product per project. ideally i would…
-
CONDITIONAL FORMATTING FOR DATE TYPE CELL
Greetings I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set. For Example, if the target for task A has reached today, then the start date for the next task should be…
-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…