-
Web Forms: Capture confirmation email into a column
Hi all, When using web forms, I'd like to capture the email address entered in the confirmation email field into a column in my smartsheet. Does anyone know if this is possible?
-
Conditional formatting not always working on "Modified (Date)" column.
I have a status sheet that is picked up in a Sight. For ease of recognizing updates, I use condirional formatting to change the text color on items modified n the last few days. This worked well initially, but now the formatting is not always being applied. The same text column is updated all the time. Not sure what I may…
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
What's the best way to show Baseline Schedule when it's not available on the Gantt?
We are using the Baseline "workaround" by creating the Actual Start, Actual Finish and variance column formulas. What method has worked for you to compare the baseline to the actual since it's not supported in Gannt view? *already upvoted this feature!
-
smartsheet does not automatically refresh
After someone submits a form, I would expect my smartsheet to refresh so I can see the new row. That is not happening nor has it since I built this sheet. I have to manually refresh the page. That's not normal, is it? What do I do to make it update automatically? Thanks
-
Feature Request: Really Lock Columns
I understand that an admin can lock and unlock columns to prevent non-admins from changing the data, but us Admins are humans too and it's way to easy to change a locked column just because I'm an admin when one is in the heat of battle of updating sheets. I'd love to be able to have, at minimum, a box that pops up asking…
-
Send an email to a contact from the sheet?
I'm building a sheet that contains various users in different roles on different teams. I'd like to email the users listed in a column when a change is made to a record. ex. I capture a program manager name in column D and when a change is made to any columns in the row, I want to email the admin (easy, set up an alert for…
-
Gantt Chart - Duration changing Start/End dates incorrectly
Hello, I am having an issue when in Gantt chart mode. If I have a start date set, and change the duration to be 2 days, the end date is automatically adjusting to be three days from the start date, even though the duration is still correctly listed at 2. This only occurs over weekends and works properly over weekdays so I…
-
Feature Request: Sheet Sharing History
I frequently send sheets internally to request for updates through the "Email Shared Users" option. While I know there's a CC me option, I think it would be more efficient if I could find a log in the sheet of when users were emailed rather than digging through my own pool of emails.
-
Program and Project Sight Templates
Hi there, I really like the look of the Program and Project sights in the Sight Gallery. Can someone send me the Sight templates and the underlying smartsheets and reports needed to make it work? I'm hoping it pulls from the Basic Project and Basic Agile templates. Thank you! - Janet
