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
Highlight Changes with a unique color, shade, or pattern for each user
I would like to submit an enhancement request for the Highlight Changes feature. The tool currently shades cells with a background color if a change has been made in the last seven days. Unfortunately, the same color is used for changes performed by everyone. I'd like to request the ability to customize the background…
Webforms & Populating Multiple Rows
I was wondering if there was a way to create a webform in basic project gantt view that allows people to populate multiple rows for dates? We have a critical path template that we want to use for our suppliers to fill out dates but we don't want them to change the content that we have listed - Just the dates. I know I can…
Turn on update request replies email
I have a SmartSheet and I regularly send out update requests. When someone responds to the update request, I'm not getting the email notifying me of the update. How do I turn that on/insure that I get the emails? Thanks so much, Janet
How do I auto check a box based on a date + x # of days?
Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick…
Integrating Smartsheet and Mercatus
Hi, Does anyone know if you can integrate Smartsheet and Mercatus? Thanks, Y
Modified Date by Cell not row
Hi, I have a use case where I need to apply current date when a specific cell is modified--not the entire row. I understand there is cell history, but need this cell modified date visible as a value in the sheet. Thoughts? Thanks, Sean
Organize formulas on a sheet
Hi I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want. So question is how best to organise formulas on a sheet, is the below…
Organizational Hierarchy
Has anyone used SmartSheet to capture organizational hierarchy or some type of org chart?
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
reminder to change oil after 5000 miles with multiple vehicles on the same sheet
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 miles since it's last oil change. I have columns for the date, the truck I.D., a checkbox for if the oil was changed that day,…