Our company will be needing Smartsheet to jump through a few IT hoops before my department can make full use if its features. In the mean time, what would happen if for some reason we had to suspend o…
I would like to calculate the number of days an item has aged. We don't currently use a "closed" date field, but rely on last modified. =IF(Responsible1 = "Closed", NETDAYS(Created1, Modified1), NETDA…
My sheet is automatically sorting my rows without any sorting or filters applied. After I enter a new row at the bottom and hit Save, the row is displaced to another location within the sheet. I need …
I want to create a purchase order form that I can send to suppliers by email from SmartSheets and receive a confirmation form back by email that the order is accepted with delivery details. The purcha…
As a new user I'm working my way through the Smartsheet product. Thanks to the 'best answer' in this post I was able to calculate the Effort (or Energy), which is visualized by 1 to 5 people-icons; th…
I'm wondering how other folks are using Smartsheet. How do you decide who gets a license versus just emailing rows or publishing editable sheets to be updated from your team? How many licenses do you …
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column. In excel i would just use a lookup or match…
Help! At the top of my projects, I am including the resources involved. I'd like for subtasks to be auto-populated when I fill in a resource. Example: in my resources section, I set the HL7 Engineer t…
Hi - I'm experimenting with Card View and am wondering if there is a way to include the field name as a label on the Card. I have multiple numeric fields that I'd like to display on the card - number …
Hello, I'm new to the application. I've created a list of collaborators and sent out invitations. A couple of them have recieved the invites but don't have access to the project sheet when they accept…