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.
Discussion List
Help with date formula
Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then scenario: If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date -…
Calculating hours from Duration colum
Hi, i would like a formula that can calculate the duration column to Hours in a text column whether i have entered h, days or weeks in the duration column. Anyone have succseeded with this?
Row Alerts
Hi I am wanting to add a row alert to all rows in my smartsheet, but wondering if there was a easier way of doing this than individually? I want an alert to be sent to the person assigned to the row task, and alerted on the start and due date for their tasks. The alert function on the bottom tab of the sheet only seems…
Change font size when printing a sheet
I see posts from 2015 but no recent postings concerning changing the font size when printing a sheet. Is there a way to change the font size when printing? Depending upon the type of sheet and number of columns, the font is too small for the majority of readers to read comfortably.
Help Us Improve Smartsheet - 2 minute survey
Hello Smartsheet Community! The UX Research team at Smartsheet would like to ask if you could complete a quick user survey. It shouldn't take more than 2 minutes. http://www.surveygizmo.com/s3/3573613/Smartsheet-Research-Study Your feedback is greatly appreciated as it helps us improve the product. Thank you in advance!…
moving info between sheets
Not sure if I am missing something something but if I copy activities from one sheet to another that have predecessors the predecessors do not transfer and so I have lost all my relationships. Is this real or am I doing something wrong?
View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
View Event/Project Overlap
We have 5 events throughout the year that each have their own sheets. These events run: December to February January to March March to May April to June August to November. Is there a way to see what parts are over lapping? Ideallly we do not want all the information in an additional sheet. But we're looking for maybe a…
Reminders
If I set up a reminder on a column in a the sheet, how can I make is stay forever. The reminder goes away once all dates satisfied are passed. I need this reminder to stay so that when new rows are added the portal send me reminders on the original rule.
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
