-
Imported Excel Binary Field to Checkbox
I've imported an excel sheet with "1's" in fields, I'd like to convert those to checkboxes. Is that possible?
-
How to open a form in the Mobile App using a web link/url
First question, I guess, is can a user, who does not have a Smartsheet account, use the Smartsheet Mobile App to enter data into a form? Now the real question. I want to configure a dashboard for maintenance workers that has links to several Smartsheet forms that they fill out and submit. I want to use the barcode…
-
Discuss work in context by leveraging updates to Conversations
Hi Smartsheet Community, My name is Diana and I’m the Product Marketing Manager for Conversations. I wanted to let you all know of some improvements that were built based on your suggestions! Deep Links to Comments from @mention Notifications - Deep links from @mention notifications brings users directly to the…
-
Subtract List Of Parts from Inventory
Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, which I list in the "Products parts list", for example: Product #1 requirements = 2 Wheels, 1 axle, and 2 wires. And the way I have set it up now, every time when I sell…
-
Formula for red flag if 3 conditions are met
Formula to use red flag if : Is Milestone is checked, the Planned End Date is today or in the past, and Done is not checked Tried the below but its not working =IF(AND([Is Milestone]:[Is Milestone], 1, [Planned End Date]:[Planned End Date], @cell >= TODAY(), Done:Done, 1), 1, 0)
-
Formula to make percent complete row = 100 if done is checked
Want the % complete cell to automatically turn to 100% if the Done cell is checked Using below but not working =IF([Done]@row =1, [% Complete]@row, = 1)
-
Status formula based on mult. conditions
How do I write a formula that would change a cell with drop down 3 tier symbols (Red, yellow, green) for the following. This would be in sheet summary - if all priority items are on time, its green. if only one is behind, its yellow, and if two or more are behind ,the project is red status Green: IF [Priority] is checked,…
-
Can an Admin see what I have created as an owner?
I have created some content for VPs, HR, etc...that others, including the person who is our Smartsheet Admin, should have access to. I just want to confirm that NO ONE, not even an Admin, can see the content I have created unless I have shared the content with them.
-
Exported PDF defaults to print when opened in PDF reader
So has anyone else experienced this? I have the feeling it has started recently, when I export a PDF and open it wit hany PDF reader it opens up the print dialog in the reader. If I restrict the use of javascript in the reader I use, the print dialog doesnt show up so I suspect there is some funky javascript thingy going…
-
How to auto send a form wkly to several contacts?
Hello I have a internal team survey which collects info via a simple form onto smartsheet. This is emailed around on Friday ea week. (the team members dont have access to the sheet themselves as it contains sensitive info) currently i have a task reminder in outlook ea wk which works but it would be easier to automate if…
