-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
Is there a way to remove someone from Resource View without removing them from a project?
Unfortunately people come and go. They are assigned tasks, work on projects, etc and then if they leave, they need to be removed from the Resource View. Reassigning future tasks is acceptable, but we need the history and want to keep them listed on completed tasks. Is there a way to do this? I would rather not have to…
-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Can a Licensed User in the Team Plan view the Admins workspaces and Sheets?
Hi, I've purchased the team plan and apart from me, I've added another project manager from my team as a licensed user so she can create sheets. This puts me at 2 of the 3 licensed users. My question is that can I prevent her from view a specific workspace in the account because even though she is a licensed user on my…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
-
Web Form Functionality
Greetings All - I am just shy of completing the academy but I do have a question to complete a project I am working on for a company. I would love to utilize the web form option; is there a way that columns, rows, and fields be manipulated in any other way? Adding fields are fine but that just adds columns and not…
-
Row Formatting Help
For some reason my rows are not aligned. Smartsheet used to auto-correct this issue, but for some reason it is not correcting it now. I tried refreshing, logging out, etc.. Nothing changed it. Please help. Thanks.