-
#DIVIDE BY ZERO” error
I have a formula in Smartsheet that calculates Accuracy by using the following formula: Estimated amount-actual amount/actual amount. Until the “actual amount” is filled in (sometimes weeks or months later) the formula returns a “#DIVIDE BY ZERO” error. The error is fine as far as the calculations go on my pivot tables.…
-
Kanban Project management
Hi Would it be possible to have a Kanban view of the projects I have setup? It could be organized easily by have a collumn with the different Kanban collumns as menu items in a dropdown menu. Then, when entering Kanban view all tasks displays as items in the Kanban collumn they belong to. This would alow a flexible…
-
Hi struggling a bit on the correct formula for overdue tasks
Hi, I need a function to look at If a column completed date is blank and the end date column date i s more than today to the return status "overdue" so I can report on overdue tasks ?
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
-
Extract top risks from risk log for highlight reporting
Hi there I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s). Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks…
-
Link to static cell in dynamic sheet?
Hi, I’m trying to figure out if a feature I’m looking for is available with Smartsheet. I have several Smartsheets, each with their own forms, for recording inspection results of various elements in a warehouse. Each time an entry is created in the form, a row is added to the top of the sheet with the user, date created,…
-
Email failure
Just recently I was not able to share any sheets or rows Any recommendations
-
Transferring Cell Data into another Cell's Dropdown List
Hello, My campany is sponsoring a walk for Alzheimer's and I'm trying to create two listed with two Webforms for our site. One will allow companies to register their organizations and Team Names and another for individuals to register themselves. Problem is I'd like the field that takes the Team names on the Team…
-
combining project plans and task lists
I am working on a fairly complex project plan with a large team. To keep track of miscellenous tasks, we also have a tasklist ( all in Smartsheet, of course ). The idea was that there are often many misc small tasks that dont have precise start/stop dates, categories or dependencies, and really don't belong on a project…
-
cell linking to task adjust end date
I keep linking my cell to a Friday milestone in another sheet. It adjusts my end date for the following monday, and now I no longer have an accurate date in my schedule. Instead of showing up as 1 day, it spans Sat/Sun/Mon, doesnt even include Friday. I can manually move it back to Friday but this of course breaks the…