-
Hide $0.00
HI when i use =SUM(CHILDREN()) it shows $0.00 value....I would like to hide this value until its greater than 0....probably easy....thanks
-
Only evaluate today() once or freeze date cell once populated?
I would like to automatically record the date a project is marked complete. I have a dropdown column with "complete" as an option. I have a "date closed" column that return today's date if the dropdown column value is "closed". Of course, the next day, "today()" wil evaluate to the current day and not the day it was…
-
Feature Request: Search Both Sheet Name & Content Simultaneously
I'd love to be able to put both sheet name and content string into the search box and it find what I'm looking for. For instance... We have a sheet named "UIN" that has our store names and unique store numbers. I'd love to be able to search UIN Woodway and it find the cell that I'm looking for. Right now, I have to search…
-
Recurring KPI Reports
Hello, I'm looking to utalize SmartSheet to document querterly KPI (performace reviews) I'm looking on a way to setup the indicaters on a report and have our team leaders fill out reviews for all team members, what is the best way of using this via SmartSheet. Your helo is greatly appricated. MH
-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children below…
-
Counting children in specific column (resolved)
I have a sheet that I'm using to keep track of about 100 projects, eventually each will have several child rows. I'm not using sheet dependencies because I want my parent row to represent how many days are left on the project. To do this I have 6 rows: "Start", "End", "Duration", "Real Start", "Real End" , "Real Duration".…
-
Training Plans and Curricula
Does anyone have any templates that would show generic training plans?
-
"Web Page" Smartsheet Solution
I need to make available, to external companies, files that contain different types of design and manufacturing standards. We currently have an external, legacy website that hosts a smaller set of similar documents. This current system won't be scalable for handling the additional requirements. Is anyone out there using…
-
Recurring sheet with sub-tasks all nested.
"sub-tasks" nested under multiple main tasks in a recurring sheet; is there any way to open all the sub-tasks at one time rather than selecting each "+" to open them?
-
Moving tasks from a project to kanban
I am trying to find a way to move tasks from a project view to the kanban card view. I have not seen a way yet to do this. When i create a new task it adds to the project, but that is not optimal. Any suggestions? Thanks, Dan Melton