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 February 2017
Discussion List
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
Continous Merge (Real-Time)
Hi everyone, I am new to Smarthsheet, and I just figured out how to merge a Smartsheet with a Google Doc and automatically send it out in an email. Do you know if it is possible to do this in real time and not as a semi-batch process? Once a new smartsheet row is added I want it to automatically merge and send via email if…
LOOKUP function - I cannot find any info on how it is supposed to work
Hi, I have read some threads but I am still not clear on how LOOKUP is supposed to work. I know it cannot function across sheets. But please can someone provide the syntax and basic data? Thanks, Ele
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
Critical Path not working
The critical path on my schedule is not working, is there a report I can get from smartsheets to see what is porssibly going wrong? or Tips on what to do?? Much Appreciated! -Marisela
Seeing all my text in Calendar view.
In calendar view, how do I get my all my text to fit? It won't wrap. When I export from Calendar view in excel, it comes to me in grid format. Exporting the Calendar view in an PDF format doesn't help becuase I cannot manipulate the text so that I can see it all. HELP!
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
Limit entry of % complete column
Is it possible to limit the entry of a % complete column to make my sheet more 'foolproof'? So only allow entries between 0 & 100 %? E.g. I use a conditional formatting rule that when a % complete is 100% that a row is 'grayed out', but if someone accidentally add 110% then no conditional formatting is applied.
Dependancy
Everytime I am attempting to change my predeccssors type (Finish -Start/finish-finsh etc) it tells me there is an error. "Circular Dependency". Can someone please give me a sample of how to setup? Thanks