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, whic…
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 mil…
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 crea…
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 % c…
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 r…
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 pr…
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 …
Asking all marketers! What is your favorite way to view your sheets? Is it the Card View, Grid View, Gantt View, or Calendar View? Do you switch back and forth? We've had a lot of internal debates abo…
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 st…
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…