-
Add formula to column without changing last modified date
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), NETDAYS(Created1, TODAY())) Is there any way to add a formula to a column without triggering the last modified system field to…
-
Auto-sorting Rows
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 to be able to clear this setting and get my sheet sorted the way it was before... with the newest entries at the bottom. Any…
-
Purchase Order Forms
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 purchase order will need an internal authorisation. A unique PO number. Entry into the Smart sheet on authorisation. Ideally the…
-
How to calculate effort relative to working hours?
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; this way Duration can be set or calculated for regular project planning, but in Card View this is automatically shown by an…
-
Number of licenses?
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 use for the size organization that you are?
-
How do I automate and validate data from one column to another
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/index to validate and populate. Cannot work out how to do it in smartsheet.
-
Using a formula =CONTACT wont populate actual contact info subtasks
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 to Joe Downing. I have it set so all HL7 tasks then populate with Joe Downing. PROBLEM: Joe Downing's contact info doesn't…
-
Field Labels in Card View
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 of teams affected, # of hours estimated, site priority. I know their positions on the card but others will not. Let me know…
-
Collaborators can't access the project sheet
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 and log in. This has not been the case for everyone. Any troubleshooting recommendations? Thanks, Ryan
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
