-
Rolling up Health to the Parent row
Is there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will? I have a formula for my children to render health, however, I can't seem to roll up to the parent. Would the same formula work the same in the parent row, if my formula is based on start/finish date and % complete?…
-
Looking for alternative to Calendar App
Hi, Community, I'm in sort of a bind as our college didn't renew our Calendar App purchase. I had built a huge planning calendar project that depended on the Calendar App to pull everything together. I am wondering if anyone has any ideas on how I can still find a way to pull up tasks from multiple sheets onto a Dashboard?…
-
Forms & Contacts - 2 Questions
I have a couple of questions: 1). When a form is completed, you can get a copy sent to yourself. Is there a way it can be sent to multiple people? Our use case is: A file review form is completed and the completed form is sent to the lawyer so, they can file it in the matter folder however, this isn't being done so ideally…
-
Droits utilisateurs - User Rights
**Translated via Google Translate** Hello, Since Friday, I have a problem with the right more access to the setting wheel. And the rights that I give to my colleagues do not change anything. Has there been an update that explains this? Thanks for your help Pascale Bonjour,…
-
ideas please
Hi We would like to develop this white board plan into smart sheet so we can access it any where we would "move" cells around as their progress ect changes ect - employees changing teams - vehicles moving from project or project Any ideas or templates out there that we could use
-
Is there a way to put a display name on a hyperlink in the Form Description?
I am trying to create a Display Name over a URL to make it more readable in the description of my form.
-
Customize Message in Automation
Hello Everyone, I need help regarding how I can get only the field that are been filled up with the data to be sent in email or notification while request for an approval. For example, I have a travel plan for 6 days of visit but the form includes of 10 days, now i have filled up the form for 6 days of travel and leave the…
-
Count Grand Children Only with Verbiage
Smartsheet Community: I ma getting the Right Count (16). However, the last Piece of the Formula is not Displaying "Total Sites Done". I tried adjust my Parenthesis but the count becomes incorrect (14 instead of 16). Current Formula: =" AsOne Invoice #1: " + (COUNT(DESCENDANTS()) - COUNT(CHILDREN() + " Total Sites Done"))…
-
How to Mask Circular Reference and Blocked Errors?
I have a SmartSheet that I have that references a Cell that calculates employee capacity. I created two cells that reference it, one is a point value, the other is a cell that calculates the percentage of the Employee Capacity cell. Employee Capacity -------------------> Action / Task Hours <---------------> Percentage of…
-
Dashboard Bar Chart - Duration by Resource
We use very basic project sheets using columns task name, duration, start, finish, assigned to and status. Our task durations are mostly specified in hour or minutes, but occasionally in days. I am trying to create a simple dashboard with a few charts but having difficulties. Chart 1 - Bar Chart - Total Duration (in hours)…