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 bec…
Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type 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…
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…
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 …
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 i…
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" Basically, i need to c…
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 er…
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 d…
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. I…