Discussion List

• Using Smartsheet to Track Employee Compliance Attestations

  In Using Smartsheet

  I'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…

  Richard Kendall

  12/03/21

  Answered - Pending Review

  36 2

  Answered - Pending Review 36 views 2 comments 0 points Most recent by Richard Kendall 12/03/21Using Smartsheet
• How can I set a dynamic filter on a report to auto change to today's date?

  In Using Smartsheet

  I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even toda…

  ayf5238

  12/03/21

  Accepted

  211 3

  Answered ✓ 211 views 3 comments 0 points Most recent by Paul Newcome 12/03/21Using Smartsheet
• Resizing Sight To Eliminate Blank Space

  In Apps, Integrations, and Add Ons

  Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leav…

  David Anderson1

  11/30/21

  916 4

  916 views 4 comments 0 points Most recent by Rosie Mariano 11/30/21Apps, Integrations, and Add Ons
• Calculate the time between two dates by days, hours and minutes

  In Formulas and Functions

  Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…

  LouiseM

  11/11/21

  3109 26

  3.1K views 26 comments 0 points Most recent by Julie Barbeau 11/11/21Formulas and Functions
• Time Tracking - Hours and Minutes

  In Formulas and Functions

  I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…

  Ezra

  11/02/21

  1585 5

  1.6K views 5 comments 1 point Most recent by L_123 11/02/21Formulas and Functions
• Export a Published Report

  In Using Smartsheet

  Hello -    I have published reports to a dashboard that my clients can go and check.  However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel.   Is there…

  Andy_DAI

  10/29/21

  118 2

  118 views 2 comments 0 points Most recent by Kevin M 10/29/21Using Smartsheet
• Edit contact display?

  In Using Smartsheet

  Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo

  JHawk

  10/27/21

  794 5

  794 views 5 comments 1 point Most recent by Genevieve P. 10/27/21Using Smartsheet
• Auto fill a second column based on a drop down selection using a form

  In Formulas and Functions

  I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…

  Dajah

  10/27/21

  8539 22

  8.5K views 22 comments 0 points Most recent by Genevieve P. 10/27/21Formulas and Functions
• Username + Password authentication is still working after disabling in Admin Console

  In Apps, Integrations, and Add Ons

  Hi all, We are using Azure AD to authenticate into Smartsheet. Recently, I disabled the Username + Password authentication option (including Administrators) with the goal of users only being able to use SSO. However, users are still able …

  tross417

  10/26/21

  Answered - Pending Review

  53 1

  Answered - Pending Review 53 views 1 comment 0 points Most recent by Genevieve P. 10/26/21Apps, Integrations, and Add Ons