Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for May 2017
Discussion List
Hidden Rows show in Email notifications
I noticed in a new sheet format we use, which includes hidden columns calculating billing and pay rates, that the "hidden columns" actually show in totality when the user send emails from the sheet or receives their sheet notifications in their email. This is an issue since I do not wish to share that information with our…
Save Icon Status
I recently created a sheet that has 303 rows by 26 columns with a lot of LOOKUP() functions in formulas (about 2040 formulas). I use the sheet to compress raw timesheet data that ultimately ends up in an Excel database. When I was debugging it was configured to handle 75 projects and it worked fine although it was a little…
conditional formatting by cells
Hello everyone, Is there any way to do conditional formatting by cells and not by column Thank you in advance.
Enable/Disable cells
Hello everyone Is there a way to make enable or disable a cells according to the values of another cell. A kind of conditional formatting with making enable or disable cells. Thank you in advance
New suggestion for the reminder feature
Hi Thanks for the great feature that you have added to the notification roles I would like to Suggest adding the customization feature to the column that we want to present in the email message for the reminder alert when we edit the message. Best Khaled
Ability to lock an individual cell
I've seen a number of community entries referencing a desire to be able to lock an individual cell. I too would vote a resounding yes to a feature of this type. I've got a number of task list sheet where this is needed. My sheets have 10 major task and each major task has a number of subtask under them. My columns are…
Best Practice for using Smartsheet as a scheduler
I would like to see the best way to use Smartsheet to notify my management and staff of the up coming schedule.
Add workdays to date
There are some columns that will be used to manage my project, "% completion", "Start Date","End Date", "Duration","Today". Now, our tasks show their completion percentage and I can see in the Gantt Chart how far the tasks run in the entire time and some of tasks seems like a bit delay from today. Therefore, I want to set…
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
Formula for calculating years accurately
We need a formula for calculating years accurately when we compare a date with the date today – some examples would be: * Age in years: Today() - date of birth, currently we use: =(TODAY() – DOB1) / 365.25 but it doesn’t always give the correct answer. The 365.25 is days in a year allowing for leap years, or * Length of…