IT & Operations
Discussion List
-
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…Answered - Pending Review 36 views 2 comments 0 points Most recent by Richard Kendall Using Smartsheet
-
How can I set a dynamic filter on a report to auto change to today's date?In Using SmartsheetI 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…
-
Resizing Sight To Eliminate Blank SpaceIn Apps, Integrations, and Add OnsHello, 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…
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, 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…
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI 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…
-
Export a Published ReportIn Using SmartsheetHello - 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…
-
Edit contact display?In Using SmartsheetHi 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
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI 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…
-
Username + Password authentication is still working after disabling in Admin ConsoleIn Apps, Integrations, and Add OnsHi 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 …Answered - Pending Review 53 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons