-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Retrieving Lost Data
I realize that this is a shot in the dark and I know it wasn't possible in the past, but does anyone know if it is possible to retrieve data that was deleted from a sheet after the sheet was then saved. If there's a way to get this back then let me know. Thanks!
-
How to submit a Template to be Shared in Template Category?
Hi! I have created a tax season client template that would be a great addition to the finance category. Travis had requested that I share so please advise on how I can share with the SmartSheet community. Thanks!
-
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…
