-
Email as form field and for copy of responses
My organization has just started using Smartsheet and I created my first form. I have a required "Email" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I announced the form and asked for feedback. Immediate and understandable feedback was, "Why do I…
-
Stacked Bar Chart with Percentages
Hi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the individual country-level progress. When I try to stack the bar chart of % complete,…
-
Combined Calendar Report - Can I Automate Labels?
Hello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on my team can see a calendar of all their tasks for the week or month, with multiple…
-
Project Health Formula to Auto Populate a Symbol
Hi I have a formula that flags the health of each row (task) via a RAG status. Green is healthy, Amber is at risk or in progress and Red is a failure. This is set up to work off the start date and % complete. However, it just isn't right. The formula is; =IF(OR([% Complete]@row = 1, Start@row > TODAY(7)), "Green",…
-
Form selection of dropdown list inserts choice with hyperlink
We have a project management Smartsheet where we have about 3 different "standard work" choices - these are selections where the requirements are the same each time. This list may grow later. On our request form, I'd like the user to be able to select from the selection of 3 different "standard work" choices, and in the…
-
Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
-
Counting number of tasks per Assigned To contact
My task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per "Assigned To" contact. It would be ideal if parent tasks are not included in that number, but it's manageable if…
-
Simple RAG status
Hi all, I am looking to create a RAG status, based on start date of a task. Rules would be: If start date is over a week away, status is GREEN If it's within one week of the start date is YELLOW If start date is in the past is RED I also have 3 simple status options, so If status is set to "Complete" I would like the RAG…
-
Hidden Columns in Reports - edit, print, send dialogues
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxes, all the columns from the main sheet are shown. Including the columns hidden in the…
-
Developer needed....
I'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.