-
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
-
Gant Chart Time Dependencies - Hours
Please let me know if anyone has figured out how to get the gant chart down to hours. The minimum that I have seen is at days and then it goes to weeks, months, and years. We have a project that will have dependencies on certain days that go down to the hour.
-
Auto-populating a sheet with filtered data from another
All, I'm hoping someone can suggest a solution. I am trying to reduce the amount of time spent re-entering data about upcoming bids from one spreadsheet to another. My company has a master list of bids over the fiscal year and every week my boss produces a separate sheet of just the upcoming bids that he can then use…
-
PERT: +/-2 sigma (Probability 95.46%)
Good Day All: How do I take the following excel formula and use it smartsheet to get the same results Excel formula =$G$30-2*SQRT($I$30) Results: 1.33 Smartsheet Formula =$Expected$26-2*SQRT($Variance$26) Results: UNPARSEABLE I tried using ^2 for square root but still receive the same results. Thanks
-
Report with resource allocation rollup
Hi, I am looking for a solution where I can roll up resources by their allocation at a portfolio level. The resource view only shows me the rollup for licensed users. However, we have users that are allocated to projects that are not necessarily licensed to create or edit sheets. They are ok with read only access. I…
-
Jira Connector + Issue Links?
Hello, Curious if there's a way to effectively sync Jira Issue Links. They support several very powerful links that help identify order of operation that would be an extreme pain to replicate in Smartsheet. Has this feature been implemented, and what's the process to connect them correctly?
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
Building A complex Sheet
Good Morning! I am looking for some help from those who are bit more familiar than I am of Smartsheet. I have just recently started to use this program and so far I find it very useful. I am not, however, using it to its full potential. I am a Sr. Project manager with my company and I need a more complex sheet to help me…
-
Status Symbols (traffic lights)
Hi - Can we have set with 5 traffic lights. There is currently four and we use them to represent on-track (green), at risk (orange), overdue (red) and complete (blue). We feel we are missing one to indicate 'not started'. You already have a grey traffic light but it is in another set of four and it would be very helpful if…
-
Symbol Column description
Can the description of each symbol be changed? Thank you!
