Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for August 2016
Discussion List
RYG Ball IF Statements
I have been trying for a few a while now to get the IF statement to work for automating the RYG to work off of end date and % complete. I would like to have it work where if the it is 3 days from complete and below 50% complete have it as red. If it is 51% to 90% yellow and 90% to 100% green. If on the last day it is still…
Feature Request: Mimic specific sheet(s) in Report
This can be done manually, but is time consuming: I would like a Report that mimics a specific sheet*. That is, the Report would display all columns in the same order as displayed in the sheet. Currently, this is a manual process which is OK for a sheet with a dozen (or even two) columns, but I'm working with sheets that…
Align Gantt chart with Timeline above?
Hi All: I'm a new user...Ihope this question is not too silly? The horizontal timeline above my Gantt chart is several days off. How do I get it to properly align with the Gantt bars below? My start & finish date columns are correct and the calender view shows the correct dates. Thanks in advance.
No webform submitted alert
Hi, I have a sheet setup for data to come in daily through a webform. What I would like to know is if there is a way for me to receive an alert if the webform has not been submitted for that day?
Formula to check percentage total
Hi I have a sheet which is pulling through some data from other sheets via cell links. The cells are being pulled from a Project Plan (with rolled up section totals). Based on this data, I want to set some conditional formatting on my sheet. I have: %COMP STARTDD ENDDD 55% 10/08/16 22/08/16 I'm using a formula (hidden…
Can you add extra columns with the Kanban view?
Can you add extra columns with the Kanban view? I would like to add this week, and today columns
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