-
Reporting on task completion rates
Hello! I'm looking for ways to report on a metric across multiple sheets, but am not sure if what I want to do is possible/how to start. Hoping someone else has had success doing something similar. Here's some background info: I want to report to my leadership team the % of tasks completed on time, across multiple sheets.…
-
Contact column
Hello, I have a problème with contact columns. I don't understand why, sometimes, for a same contact, the cell display one time the first and the last name (what I want), and an other time, the mail adress : Do you know what's the problem ? Thank you for your help !
-
Pie Charting a Sheet Summary Report
I have added a RAG status to all my projects in the Sheet Summary view. I can pull a report showing the projects and their RAG status fine. When I then try to pie chart the RAG status onto a dashboard this is not possible as the RAG status is not a number. So I added a number field and populated it with '1' so that I can…
-
Link sheets to a master sheet
I would like to link my sheet/cells/rows in my To Do sheet to my boss's Master sheet, so whatever change I make in my sheet, e.g. adding rows for additional tasks, would automatically show up in his Master sheet. He wants to have a sheet where he can view everyone's sheets at a glance in one place. I tried cell linking,…
-
Lookup item in sheet and move data.
Hello, I would like in a form input a tagnumber like 1212122. Then after the form is submitted smartsheet will lookup this tagnummer in the main sheet. Then if found move the complete content of that row to another sheet and ( not just the form contents ). I made this tagnumber the primary column in both sheets. i am able…
-
Relative Default Date in Forms
I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.…
-
Auto Number
I own the sheet that we are currently using, and am wondering if I can override the values for several cells? I made a change to the format which I reverted, but three requests were submitted in the meantime. Anyway to change those?
-
Form input to a categorized view
I'm using the Project Mgmt Office template. I'd like my form data to populate a sheet that looks like the above screenshot. Can a new form submission populate child rows under "New" category? And, once the status of project changes from "New" to "SCOPING", can the sheet update automatically and the child row appear under…
-
A workflow has become invalid
Hello, I have had this problem for over a month! I receive the notification "A workflow has become invalid" and I go to the workflow, delete it and do it again. It works for a while and then it happens again. I already set the "Automation Permissions" to Unrestricted and it still doesn't work! I followed up with the person…
-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
