-
Two jobs in one spreadsheet?
Hi, Thanks in advance for your help. I have two sets of duties within my position: one set as Sustainability Engagement Coordinator, and one as Energy Coach. How can I use smartsheet to track the amount of time I spend each week on work for each set of duties, and track projects on each? Or do I need separate sheets for…
-
Changing File Directory for downloaded attachments
Hi all, For context, I use a Form to manage incoming service requests and generate PDF Work Order attachments. I would like to change the file directory for downloaded attachments to a shared folder rather than 'Downloads' so my supplier has visibility of the work orders when they are assigned. I can't seem to find an…
-
Elapsed Days Counter - How?
Hi everyone, I'm needing to report on elapsed days for a few tasks. Anyone know how to do this? Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet. Any help is greatly…
-
Merged: Project Timeline: new view
This discussion has been merged.
-
IF Statements when a score / number is between two values
Hi there! I'm working on a dashboard which will show the overall "health" of a program. I'd like the health score I've already devised to display on a sheet as "Red" "Yellow" or "Green" depending on if the score falls in a certain range. For example, if the score is less than 84.99, display "Red", between 85 and 94.99,…
-
File Upload to Resource Management - projects
In RM, I need to be able to upload a PDF or Word document to Projects to track SOWs against the project. It would be helpful to be able to load directly to the project.
-
Portfolio Management: Team member part-time availability on Projects
I need the ability to set part-time availability for a team member to specific projects, i.e. working Mon-Wed on Project A and Thu-Fri on Project B. For each project and each team member you could set working days, that would solve this problem. I have a team member in high demand, between two projects an agreement was…
-
Implement the capability to allow records to be moved to a different row and remain intact
This is in reference to the support case #06202095: https://supportportal.smartsheet.com/s/case/5005a00002WaZM4AAN/issue-with-data-insertion-and-moving-them-see-detailed-description Summary of the case I use a plugin called Smartsheet for Jira Connector to sync data between Jira and smartsheet. The issue is that when I…
-
Change a form submission + approval needed
Hi all, I'm working on a build request is asking: use form to submit new project - DONE be able to revisit the prior form submission to change certain key fields the key change needs to be approved before data change is made on the sheet Can someone provide some ideas for step #2 ? some posts mentioned about Dynamic…
-
Resource Management by Smartsheet is now localized in additional languages
Exciting news! Our latest release of Resource Management by Smartsheet enhances our global customer support by providing seamless language compatibility. Now supporting the same languages as Smartsheet - English, French, German, Italian, Japanese, Portuguese, Russian, and Spanish - it leverages automatic detection based on…