I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
This discussion has been merged.
Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in…
I think it would be good if we could have customisable (to an extent) on sheets or an option that people are allowed to do so if granted access on a sheet. Some people wanted "highlighted changes" or "frozen columns" on and other do not. Is there a way to add it to your filter maybe so people can opt in to those being on?
What would you suggest to a customer who is looking to use the proofing tool to collect comments and request approval but would also want to be able to make changes to the word document without having to leave Smartsheet? At the moment they have to go out of Smartsheet, find the document in Sharepoint and edit the…
Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated using several weighted questions in the Sheet Summary that populate either a 0 (non-urgent) or 1 (urgent). This setup…
I'd really like to have the ability to lock a column width and/or have the column remember each person's/device's last width setting. See: https://community.smartsheet.com/discussion/87852/lock-column-width I work with several sheets multiple times a day that I share with a co-editor. Because of differing screen sizes and…
Hello Smartsheet Community, I hope you're all doing well! Im relatively new to smartsheets and I'm currently working on an automation process using the API's within Smartsheet where new sheets are created from a template. This template has an attached form that is crucial for our workflow. Currently, we can retrieve the…