-
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…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
-
Row Formatting Help
For some reason my rows are not aligned. Smartsheet used to auto-correct this issue, but for some reason it is not correcting it now. I tried refreshing, logging out, etc.. Nothing changed it. Please help. Thanks.
