-
Can I link TO another sheet instead of linking FROM?
I need to link my issue log rows to a master issues log in a different workspace in SmartSheet. However, my boss does not want anybody to make changes in his worksheet unless those changes are done by linking our issue rows to it. The only thing I have been able to do is go into his master issue sheet and link to mine. Can…
-
Smartsheet and Asana
I'd like to be able to send things from smartsheet across to Asana and vice versa. Ideally I'd like to be able to send steps in Asana across to projects in Smartsheet. As Smartsheet integrates way better with google Calendar etc. Is this possible? What can you transfer between the apps? What can't you transfer? Thanks!
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
-
Automatic Staff Details
Hi All Is it possible to have detials auomatically filled in for a person. Eample i select person x from a drop down list to work on a course, the spreadhseet then gets the phone number and email adress of person x from a sperate spreadhseet and auto fills it. Thnaks in advacne for your help. Matt
-
Communicating "definitions or conventions" SmartSheet
All, I am new to SS. As I post a roadmap in SS I would like to communicate "definitions" in help text or somehow to the viewers of the SS. For example, I will have color flags to provide project status in terms of scope, schedule, cost, etc. How can I help the viewer understand my definitions for green, yellow, red?…
-
Column Dependencies/Conditional Formatting
Is there a way to have one column populate data based on information put in a second column? For example, I have 2 columns "% Complete" and "Task Status" I would like that if the % Complete is at o% the Task Status would auto-populate to say "Not Started". And if the % Complete is 100% the Task Status would automatically…
-
Webforms
I have a sheet that I've already created and I only need non-smartsheet users to fill out the address column. Can I make my current sheet a webform and require them to enter data into an existing cell by selecting their names?
-
Exporting to DOMO - columns being read as Text not Number
I currently have smartsheet connector to DOMO to create reports; however, the columns that contain financial data come over as text because smartsheet's column properties are Text/Number. Not Text, Number separately. Anyone know how to make this work? or a workarond? Thanks