Media & Entertainment


Discussion List

  • 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…
    2664 26
    2.7K views 26 comments Most recent by Julie Barbeau Formulas 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…
    1354 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions
  • Avoiding #INVALID DATA TYPE when cells are blank
    In Formulas and Functions
    Hello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the dark grey row) is calculated as follo…
    1455 6
    1.5K views 6 comments Most recent by Amy Shank Formulas and Functions
  • Date Modified
    In Formulas and Functions
    I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…
    2687 11
    2.7K views 11 comments Most recent by PeterNYU Formulas and Functions
  • Calculating Time in HH:MM:SS
    In Formulas and Functions
    Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more de…
    388 19
    Accepted Answer 388 views 19 comments Most recent by SteCoxy Formulas and Functions
  • Reminder email font issue
    In Using Smartsheet
    Good morning, Since the recent changes in the layout of reminder emails, I've noticed that the font for the text box field comes through very small. On my end, it looks like it's around a 6pt Arial.  Is there a way to change it to a larg…
    62 4
    62 views 4 comments Most recent by Jack Russell Using Smartsheet
  • Import Excel file and include embedded images
    In Using Smartsheet
    Hi,  I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something?   Or do I have to re-import those images manually,…
    176 3
    176 views 3 comments Most recent by slaflen17131 Using Smartsheet
  • Integrate with Microsoft Access
    In Apps, Integrations, and Add Ons
    Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
    1538 3
    1.5K views 3 comments Most recent by Marian Hanright Apps, Integrations, and Add Ons
  • Duration formula
    In Formulas and Functions
    I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates.  As such, somewhere I have lost the duration formula in that column.  Can someone please help me with the formula that wo…
    3800 6
    3.8K views 6 comments Most recent by Kelly Moore Formulas and Functions
  • Multiple Sheets & Formula Updates
    In Formulas and Functions
    I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas …
    Answered - Pending Review
    63 2
    Answered - Pending Review 63 views 2 comments Most recent by Mike Rini Formulas and Functions