-
Limitations on design - Can I put a forumula in a cell in a date column
Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on a sheet a column is a date or drop down etc. and I want to use a cell in that column in a…
-
Authentication to Web Request Forms.
Hello All, Our IT Department does not like that any registered user of smartsheets can access the web request if the have the url. The solution would be a username and password authentication to allow access to the Web Request that allows only who we want to have access to it. Doe anyone have a solution?
-
Changing the Color of a Parent Task Bart in Gantt Chart
Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-format-milestones-summary-bars) that says if dependecies are turned on, then gray is the default…
-
How to find the percentage complete for a project
Hi guys, I want to know the percentage complete for my project. I have 10 tasks below my parent. If 3 of the tasks are checked, I want the parent to say 30% completed. I am using the formula below to find out how many of the boxes are checked. I could replace the 1 with a 0 to find out the number unchecked. I could do a…
-
Discussions: Email a Comment
Smartsheet, In the Discussion feature, I find myself needing to write a comment - then click SAVE - then click on the "Email Comment" button - then fill out the person's (or people's) names in the discussion and then click send to get the comment out to the Team. Is there a way - OR can you add a feature - that allows me…
-
Unable to Connect to Office 365 via Outlook App
Non Global addministartors are unable to Connect to Office 365 via the Outlook App. All users here have logon access to the O365 portal. Othe Outlook apps we are using login with now issues. Users are getting a pop screen stating ------------------------------------------ Sign In Sorry, but we're having trouble signing you…
-
Curriculum Project Management
Hello, I recently became a curriculum manager and want to utilize Smartsheet to oversee the annual curriculum, the coordinators, and take on a project management role. Has anyone used smartsheet in a similar way and if so, do you have an example of what you're using? Do you have any tips for me as I get started? I…
-
Conditional exclusion of rows
I want to have a sheet where based on a condition like a checked box certain rows are or are not available. For example if CAPEX is not checked then the Capex task rows are not available to see. Is this possible
-
Report Blank
Hi, I'm trying to create a report based on a sheet I'm an admin on, but it's coming up blank. I build the report based on that sheet, so all the column match. If I select a different sheet it works & shows all the information. I tried deleting it & starting over, still seeing nothing. Not sure what's going on. Help? Thanks!
-
HIPAA Policy Change
Hello! Originally, Smartsheet was set up as a HIPAA compliant item. Can anyone clarify when this changed and what justification caused this change? I have reached out to Smartsheet but they haven't gotten any feedback. Does anyone else know? Thanks!