-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
Google form → SmartSheet → E-mail Alert
I created a google form that is linked to a smartsheet. (I had to create a google form because smartsheet doesn't have a multicheck option available for the web form capability). I'd like to use the alerts capabilities of SmartSheet so when someone fills out the google form, the answers to go the smartsheet, and it will…
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Can a Licensed User in the Team Plan view the Admins workspaces and Sheets?
Hi, I've purchased the team plan and apart from me, I've added another project manager from my team as a licensed user so she can create sheets. This puts me at 2 of the 3 licensed users. My question is that can I prevent her from view a specific workspace in the account because even though she is a licensed user on my…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
-
Web Form Functionality
Greetings All - I am just shy of completing the academy but I do have a question to complete a project I am working on for a company. I would love to utilize the web form option; is there a way that columns, rows, and fields be manipulated in any other way? Adding fields are fine but that just adds columns and not…
-
Row Formatting Help
For some reason my rows are not aligned. Smartsheet used to auto-correct this issue, but for some reason it is not correcting it now. I tried refreshing, logging out, etc.. Nothing changed it. Please help. Thanks.
-
Smartsheet is not available
A few minutes ago I tried to start Smartsheet in Chrome, but got the following message: "Smartsheet is loading... It is taking longer than normal to load Smartsheet. In certain cases, a network or internal anomaly will prevent Smartsheet from loading. Press the Refresh button on your browser to re-load Smartsheet. Please…
-
Conditional Formatting - Filter odd/even numbers
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
