-
Resource allocation total per group
Hi there, I can see in resource view, you can see the individual resource utilisation, but can you see a aggregated total per group anywhere, without having to export to excel and adding formula's? Cheers Paul
-
Automated Workflow or Assign Tasks to prioritise requests
Hi, I am hoping someone can assist me! I have a smartsheet which contains capital requests received from Local Governments (via a grant application process). I have included a ‘region’ column & ‘regional contact’ (contact list) column so I can hopefully create a workflow conditional on region for the specific contact. Once…
-
Dynamic dashboard using year wise data
Hi, In smatsheet how to create year wise dashboard. User select year and chart graph change dynamically as per year data.. it's possible using smartsheet ?
-
How to embed a Smartsheet URL of a gantt onto a Dashboard
Hello. I am trying to put a gantt onto a dashboard. The advantage of using the web content widget is that you can visualize the indented hierarchy and in fact collapse it for a higher level view for some audiences, but expand it when you need to. Below is a picture showing the sheet that I am embedding as the web content…
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Is there a way to mass update permissions on a sheet?
I have 25 sheets that need to have the permission level changed for about 25-50 users per sheet. Is there way to do this all at once, or do I have to check each person on each sheet to viewer access?
-
One person has multiple jobs on one day
Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigned to and adjust the start dates of other jobs based on available slack time (away…
-
Formula to restrict the parent row status from being complete unless all child rows are complete
I need it to also take into account that some don't have child rows. Here is the formula I'm using, however, when a row doesn't have any child rows it is triggering a not started result. Could someone assist? Any help would be much appreciated! =IF(COUNTIFS(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started",…
-
File Storage for Global Intake Form
Hi there, I just wanted to clarify that the limit (250 MB for Licensed user) is based on the full sheet storage, correct? Not per upload? I'm a licensed user and am creating an intake/approval form that would allow others from around the world to enter data and store items (like donation receipts, NDA's, Contracts etc.).…
-
CountIf NOT equal to 100%
How do I create a CountIf function for all cells that DO NOT equal 100% under a percent complete column? I tried the both of following but they do not work: =COUNTIF [% Complete]:[% Complete], <> =1) =COUNTIF [% Complete]:[% Complete], <>1)