-
Application Engineer uses Smartsheet to manage fast moving projects
Hello yall! I am an application engineer who uses a simple Smartsheet to keep track of all the projects that I am working on. Previously I would rely on folders in outlook to keep separate projects distinct, however Smartsheet allows me to see what I am working on and what I have finished!
-
Formula Help Within Sheet
Alright, SmartSheet community. You've always been good to me with helping out. I've got a real "stumper" here. Let's say I have six columns on my sheet (in reality there's many, many more; but these are the ones relevant to my question): Start Date (a Date/Time column type) End Date (a Date/Time column type) Allocation %…
-
Smartsheets Budget Forecasting
Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.
-
Merged: Kanban Grid
This discussion has been merged.
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Auto Refresh for Reports
I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need to see all the columns on that sheet. This works well, except the user is forced to save and…
-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…
-
Formula to countdown contract expiration dates
I have a sheet that lists all active contracts for my department. The sheet houses the contract details such as Contract Name, Contract ID #, Vendor, Start Date, End Date and Extension Date, etc.… I am currently using =[Expiration Date]@row - today() as the formula in an adjacent cell to countdown the days until the…
-
COUNTIF with Parent rows only, exclude children
I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…