Media & Entertainment

 

Discussion List

  • 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…
    Accepted
    764 21
    Answered ✓ 764 views 21 comments Most recent by SteCoxy Formulas and Functions
  • COUNTIFS across multiple columns
    In Formulas and Functions
    Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operatio…
    Accepted
    135 12
    Answered ✓ 135 views 12 comments Most recent by Andrée Starå Formulas and Functions
  • Free Webinar: Collaborate on Content with Proofing
    In General Announcements
    Join us January 27th for our webinar "Collaborate on Content with Proofing." On this webinar you will learn how your team can review and approve content with Smartsheet Proofing. We will be hosting 3 sessions across multiple time…
    52 0
    52 views 0 comments Started by Victor Agudelo General Announcements
  • 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…
    3344 13
    3.3K views 13 comments Most recent by Andrée Starå Formulas and Functions
  • Hyperlinks Not Exporting
    In Using Smartsheet
    We use our Smartsheets to track our production process. This includes having hyperlinks to the items on our Google Drive. Last week we were able to export this sheet and the links worked without any issues. Today, when we export to Excel, …
    81 2
    81 views 2 comments Most recent by koboyle Using Smartsheet
  • 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…
    3113 26
    3.1K 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…
    1589 5
    1.6K 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…
    1861 6
    1.9K views 6 comments Most recent by Amy Shank 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…
    82 4
    82 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,…
    228 3
    228 views 3 comments Most recent by slaflen17131 Using Smartsheet