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.
Discussion List
Cell linking within the same sheet
I have a project where I have a start date and due date for each of my tasks, however on a calendar report sometimes I want the start date to show up on the calendar (when it GOES to reviewers) and sometimes I want the due date to show up on the calendar (when the analysis needs to be COMPLETED). I've created a summary…
Can I filter child rows based on Parent row task name
Is it possible to filter a sheet based on the Parent Row task name? For example, if I have some child tasks that fall under the parent task name "Electrical" and some child tasks that fall under the parent task name "Mechanical" and I want to only see the parent and child rows for "Electrical". My sheet may have several…
Critical Path with Start-to-Finish project sheet.
Hello, I have set up a project sheet that has a fixed finish date so I have set up dependancies in all my tasks on a Start-to-finish basis. All good except it look like Critical Path doesn't work with sheets set up like this. Any advice gratefully received.
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…
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…
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…
telephone integration
I've been asked if SS can integrate with a telephone system so that phone numbers in a sheet can be dialled directly from within SS? We use SS to track customer prospecting and to log any contact with potential customers. Being able to call directly and then to log the date/time etc as well as prompt follow up would be a…
Pre-select certain rows for export to PDF
Community: I run a regular export of a Gantt chart to PDF, and select pertinent rows to include in said report. I do this daily, and currently, have to go in and manually Ctrl-Click to select the same rows over and over... I know I can make these rows at a high level, and then collapse the items below, but the way the plan…
Try out upcoming Smarsheet features
Update: We have all the responses we need at this point. Thanks everyone for your input! We'll keep you posted the next time we have early features to show you. Best regards, Daniel -------------- Hi all, We're working on new features in Smartsheet designed to help you stay on top of work requiring your attention. We'd…
