-
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…
-
Multiple discussion for one row - MISSING
Hi, Since the last update it is not possible to make more than one discussion per line. Please make this undone. I'am really unhappy! Best regards
-
Feature Request - Sort/filter by History
OK, so there are many useful applications for being able to sort rows by the history of the cell. In one way this is possible if you have the 'date modified' column in your sheet, but this only shows that something in the row was modified. If you have multiple columns, this requires you to check the cells for which changed…
-
Updates to SmartSheet - do other editors/viewers get notified?
When a smartsheet is updated or changed, do other editors/viewers get notified of changes? Or, do they simply see them when they login?
