-
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
-
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
-
Format date columns in a Gantt chart
I want to be able to highlight the date column in the Gantt view when I have allocated work for one client on a particular day so that I can see which days are free for work on another client's project, without having to expand the child rows every client. The weekend columns are highlighted, what I'm looking for is just…
-
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…
-
Add meetings to Calendar
Hi ladies and gents, Maybe I am trying to make this just all too difficult. Can I add multiple 'meetings' with start and end times into a calendar anywhere within SS? Everything I can find that is calendar based has only 1 line, for one task input. I think I am after something similar to say, Outlook Calendar, just within…
-
Master Smartsheet for all of our Teams Projects
We have around 25+ active projects with Smartsheets on our Project Management team at any given time. Has anyone created a template for a master template for your team's portfolio of projects. Any tips or tricks?
-
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.
-
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…
-
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)
-
Combining form data with a to do list
We collect reservation request information via form that I can pull into a sheet. However, I would like to have a task to-do list/deadlines/confirmations noted, etc. on the same sheet. My understanding however is that the columns can only be formatted all the way down. Does anyone have a suggestion as to how I can…
