Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Smartsheet data to SnowflakeIn Apps, Integrations, and Add OnsWe have a need to import Smartsheet data into Snowflake. Does Smartsheet have a way to save to an S3 bucket so we can download from there (using Glue maybe?), or is there a preferred method for doing that? Thanks
-
Using Smartsheet to Track Employee Compliance AttestationsIn Using SmartsheetI'm wondering if anyone has created a managable way of tracking the status of employee policy attestations across 100+ employees and upwards of 20+ compliance documents. I've downloaded the Smartsheet Policy Governance Templates however t…
-
Importing from Excel to Show Changes from Prior ImportIn Using SmartsheetI have an Excel spreadsheet that I need to import into Smartsheet. The Excel sheet is generated every couple weeks, which means some of the data may change from version to version. Once I create the initial Smartsheet sheet, is there a way…
-
Subtracting months from a DateIn Formulas and FunctionsHello, I found the below formula that works to subtract months from a date field, however it only works when its going into another year. If its within the same year it does not work and receive an Incorrect Argument Error. =IF((MONTH([Day…
-
Creating a dropdown list from values in a column on another sheetIn Formulas and FunctionsI am trying to create a simple dropdown list of values to select from a customized list of values in another sheet. This list will change over time, so I want to use this reference sheet to update the list values. I have setup the list in…
-
conditional formatting not workingIn Formulas and FunctionsI'm trying to make my conditional formatting work so that a column is highlighted a specific color is the % Completed column is over a certain amount and the Due Date is in the next 7 days. I even moved this rule close to the top of the li…
-
Stuck on a formulaIn Formulas and FunctionsHello, I'm trying to create a formula that essentially takes a predetermined number and subtracts 2 sets of other numbers (both a sum of column values and then also subtracting a cell number minus a %). Wow, I've just confused myself. E…
-
Help with multiple criteria within a date rangeIn Formulas and FunctionsHi I previously received help with a formula to count the number of a specific activity 'last month', which was then adjusted to take account of the change into a new year. The formula I am using is: =COUNTIFS({Product Specialists Activit…
-
Using COUNTIFS with CONTAINSIn Formulas and FunctionsHello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("…Accepted Answer 2.4K views 14 comments 0 points Most recent by Chris Grinstead Formulas and Functions
-
Is it possible to remove the source sheet link from automated email notifications?In Using SmartsheetSeveral times a day I get requests to share a source sheet to a user who received an automated alert. Since the body text is small and the source sheet link if big and in a different color, i can understand why they are clicking on it. I h…Answered 465 views 14 comments 5 points Most recent by PharaK SupportServiceManager Using Smartsheet
