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 July 2016
Discussion List
I would like to change a cell if an attachment is received
I need to send reminders to suppliers for them to attach specific files such as datasheets etc. Once the file has been received I would want Smartsheet to stop sending further reminders. I think possibly a solution is for a cell to change status if an attachment is received. I could then create a logic statement which will…
Evernote business card items directly to specific columns in Smartsheet
Is it possible? I don't want to just attach a Note from Evernote. Is there a way to that the details from a business card from Evernote will go to specific columns in a Smartsheet sheet? For example, the email will go to column D, the phone number will go to column E and so on... Thank you
check box formula
I am trying to get a check box to automatically check itself when a range of other check boxes are checked off, I have tried a few formulas with no luck, below is my latest formula =IF([Sand 1]294:[Sand 1]310 = 1), 1)
Auto-Complete
Hi, How do I enable auto-complete in SmartSheet? I am designing a form for linguists to borrow items for fieldwork, and it would be great if their name, e-mail address, fieldwork location etc. came up as an option when they started typing in a cell. Thanks, Jen
Web form access to registered users only
Hi, I want to provide the acess of web form (via link provided) to only registered users and want to fetch the user in same form who has accessed it. Eg. If userA fills up the form and sumbit, my web form sheet should show Form filled by "userA" Please suggest.
Blank cell in auto numbering
How do I remove auto numbering from one cell in a column so it is blank and numbering continues in next row?
Turning on auto numbering
How do I turn on auto numbering for a column? I have followed the instructions in the help section however the cells in the column where I have turned on auto-numbering seem to be frozen and there are no auto numbers in them. The instructions seem simple enough but aren's working for me. Is there something I'm missing?
Formulas
Hi, I have started an Inventory Control sheet for my husbands business. He doesn't keep a lot of stock, but needs to know when things go in or out for ordering. I have set up the coloured balls to automatically indicate when stock is needed to be ordered, but would like to be able to automatically keep a running stock…
Shared to me status to Owner status
I am currently "shared to me" access with Smartsheet. I now want to have my own plan and create sheets of my own. When I login I can see the sheets that are shared to me from another owner. Do I use the "create new" tab beside the sheets I can see. Will anyone from the original owner's group be able to see the sheets I…
Why can't I send a weekly update request for a whole sheet - not just a row / web form
I would like to send a regular Update request for a whole sheet - not just a row in a sheet. Alternatively I would like to be able to set an Alert to go out automatically every week / fortnight / day rather than according to a specific date. At the moment I have to set up individual alerts to go out every fortnight. which…