-
Excel Converstion to Smartsheets
Does anyone know if there is a way to smart-sync Excel documents into Smartsheet? For example, I have an Excel file that I dump into a Smartsheet schedule each day. But I am running into the tediousness of having to personally sort the file to make sure I am not duplicating information, and then copy-pasting all physically…
-
How do I give an outside user access to ONE row of a spreadsheet?
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to inform the editors of anything they need to know about, etc. One of the questions asks them to upload photos they took from…
-
Pull data from excel and update Smartsheet
Hi everyone.. I am new to the community..so hopefully my question is not too stupid :D I am currently using Excel to calculate a value by using the normal distribution formula. I would like to pull this value from excel and then update a cell in Smartsheet. It is an on-going exercise so the fetch should be done regularly…
-
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?
