-
Create Hierarchy Relationship using WBS and Formula?
Hi, I believe this may be a bit of a stretch but I am wondering if it is possible to automatically create the Child/Parent relationship utilizing the numbers or periods in a WBS # column as a way to automatically create the indention. I have built a pretty good process using Smartsheets data uploader to import external…
-
Convert week numbers back to physical dates
Hi, I am new to smatsheet. I have transferred an excel file into smartsheet. After some use I have decided I don't want to use week numbers, but dates so I can leverage the power of smartsheeet. I found the following code =DATE(2019, 1, 1) + 7 * ([Task Start]1 - 1) It was originally for 2018 so i simply change the 2018 to…
-
Curious about Form capability
Hi, would it be possible to use a form to get data into a sheet and instead of creating a new line of data it can add into an existing line? Attached an example.
-
Auto-populating between two sheets
I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically become options in a drop-down box for another sheet. Is this possible at all, or is this a…
-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
Can we link Smartsheet to MS Access
Hi Team, My requirement is can we link Smartsheet to MS Access to Import Smartsheet Data to MS Access table. If yes...? Please provide the steps.
-
What is the best way to backup my data in Smartsheet?
My company is adding a lot of important and senstive data to our sheets and I am concerned that one of our users might accidently delete data that we need. What would be the best back to backup all of our sheets? Is there feature that will automatically backup our sheets?
-
Mass contact upload without notifying
Morning community buddies, I am looking to upload all of my companys' contacts into Smartsheet for two reasons: 1) So anyone in the business can appear in a contact drop-down - as some may not use Smartsheet but we in the PMO would be able to track resources - free text could lead to mistakes so it needs to be the same…
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Smartsheet export to excel corruption error
My team has been exporting a Smartsheet to Excel for over a year now then 5/30 we started getting a corrpuption error on our export to Excel (see attached Corruption1 & 2 Attachments). Trying to firgure out why this is happening now. I submitted a help ticket to Smartsheets however they miss read and assumed i was trying…