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 2016 Posts
Archives for April 2016
Discussion List
Print with Sheet Name on All Pages
The sheet name only prints on the very first page, and I have to write my sheet names on the top of the other pages all the time. Since there's an option to print with the page numbers & time stamp, it'd be great if there were an option to have the sheet name on every page, insead of just the first one. Thanks!
Add number of months onto a date
I have a sheet that summarizes all of our projects. I want to add the projected term of the project (in months) to the kick off date of the project. Here is what I came up with but it is not working: DATE(MONTH([Kick Off]1) + [Project Term]1) Is there a formula that I can reference the date on one cell and add...say "6…
Dates not lining up
My editorail calendar isn't lining up when I sort by date. My April dates are below July. I'm not sure what's happening with the formatting.
Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
Web Form Question
How can I deactivate a web form and issue a postponement or will be rescheduled message at the same time?
Locking a row when a check box is selected
Is it possible to have a row "lock" when someone selects the "check box" column, so they (Editors) can not change data on that row?
Conditional Formatting based on a cell text formatting
Hello hive mind. I am familiar with IF statements and Conditional Formatting, but I am not seeing a way with either of those for the followng. I would like to set a Conditional Formatting Rule to highlight a row to a certain color if the text in a particular cell is in bold. There does not seem to be a way with Cond. Form.…
Organizing/Sorting Workspaces
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ideally, I would like a way to group all the reports together and all of the sheets together. An anaology is clicking the…
Notifications with selected columns?
Is there any way to limit the columnd included in notifications? I have a sheet with a large number of columns and the e-mail notificatons are not legible due to the number of columns included. See below This is an option when sending rows and update requests, it would be nice to have this as an option for notifications.…
Counting non blank cells
How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.