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 2017 Posts
Archives for April 2017
Discussion List
ENHANCEMENT REQUEST: FROM YOUR CUSTOMER BASE
Open Topics Pending Product Reply on: * Fix the link to sheet bug not showing as a URL/link * Unable to unlink, delete and retype in text to fix * Ability to chance the background color in a Sight other what white/grey - fix to allow users to select a color or image upload * Ability to make widgets transparent and just…
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
Import multiple excel sheets into one Smartsheet
Does anyone know how or if you can import multiple excel sheets into one smartsheet?
Allow multiple sheets to be selected for the same new Alert
Allow the same new Alert to be created for several selected sheets at the same time. When starting a new project, I take a workspace and Save As New to get the sheets, reports, and folders. It would save time to be able to set up all the new Alerts on the new sheets at once. This would not be needed (for this use case, but…
Gantt view default??
My gantt chard defaults to the earliest date in the sheet. I need it to default to today's date. Help?
Card View
Any Card View Users? See Screen Shot How can I get Card View to specify the Column Name on the card? Ex: On the Left Card - "JOB# 10002121" 10002121 is JOB# Column but when I'm looking at Card View it doesnt clarify that. I can work around this by manually adding "JOB#" in the cell before the #s HOWEVER, when it comes to…
If all children are not blank then enter a phrase
Hi I am having trouble writing a formula that will return the phrase "Completed" in a cell of a parent row if all the children are not blank. If there are some blank cells then it would return "Not Completed". I am trying to get the word in the parent row in the column "Opera Analysis Code", if all the children have…
Sights & Gantt Chart
In my report, the Row description is showing on the gantt chart as I have set-up. However, when I look at the Sight Gantt chart it is gone. Also, my project starts in March and it keeps going back to January 01 for the display. This results in a lot of blank data that is useless.
Alert notification for when column goes from blank to...not blank?
Hi all, Looking for a way to receive a notification for the first instance in which a cell goes from blank to filled. We need the date on which a designer is assigned for any given "GRS" project - but that designer may change over time. We are only concerned about the FIRST update. Any ideas on how to set up this kind of…
.dwg files as attachements
I uploaded .dwg files as attachments but can't open them from Smartsheet. Anyone else using .dwg files?
