Hello! I've been trying to count how many milestones called "Testing" with %Complete = 100% are per project. Each milestone is a child of a parent called "Milestone" and this is at the same time a child of the project name. At the end, each project is a child of a big project name. (I've attached an example of the…
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only be able to do it using…
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times per day. We've been getting a ton of work done without ever changing out of our pjs!…
我是一个管理员在动态竞争w and have created a new view. I want my staff to be allowed to submit new items. I have selected that as an option but cannot figure out how to have them actually add a new line. Help!
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available information are complicating the situation as individuals and organizations seek to…
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Date]9 < TODAY(), NOT(Status9 = "Complete")), 1, 0) but I need to update it because I…
