-
Recover smart-sheet project plan from previously saved copies
the owner of a project plan has mistakenly deleted a great deal of lines in the master plan. my question is, can a smartsheet project plan be recovered from previous saved versions? greatly appreciate any feedback that can help to recover a recent copy of the plan Renato
-
Conditional Formating between 2 dates
I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
-
Authentication when accessing from Tableau using ODBC
Hi there, I use Smartsheet as one of data sources in Tableau. I would like to know if all work fine when using someone else's Smartsheet Access Token. Edit Datasource User name and Pasword - owner of Smartsheet I will add screenshots also.
-
How can I allow Viewers but prevent them from getting an update very time that i make a change to a
How can I as an Administrator allow Viewers to a sheet but prevent them from getting an email every time that I make an update to the sheet? I was not aware that these were going out to every person who has Viewer access.
-
I want to add sprint into my agile project plan
How do i add extra sprints?
-
Smart Sheet for tracking customer onboarding process for Saas company
Hello Smartsheet community members, I am on trial and trying to learn ways to setup smartsheet in order to track customer onboarding process. My company is creating and selling software to customers (Saas) and we are looking for ways to improve our internal communication to help our customer adaping our software quicker…
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Imported Contacts not 'syncing'
I imported an excel spreadsheet that has a column of names. The column was imported as text. I changed the column property to Contact list. As I add people to my account contacts, the rest of the cells in that column with the same name are not sync'ing (?). Smartsheet wants me to add another contact entry. Is there a way…
-
COUNTIFS to ignore "#Missing or Invalid Paramaters"
hello, I have a column that use "Networkdays" to calcuate the "Start" and "End date" of a row. Example: Project Name: Start Date: End Date: Duration ----------------------------------------------------------------------------------------------------------------------------- Project A 11/16/2015 11/17/2015 2 Project B…
-
Moving Uploads from a Sheet to Google Drive
We would really need a feature that allows us to move uploaded files from Smartsheet to Google Drive and have a link to this file in Smartsheet instead. If Smartsheet is not offering such a functionality might it be possible to find a thirdparty app that offers this? Any idea would be appreciated.
