-
Scrolling on a mac
Having a problem using a mouse to scroll down on a sheet in grid view using Safari browser on a mac. When I use the mouse to try to scroll up or down, it jumps me to a different screen. I have to click on the sheet and use the arrow keys to move around. This is very frustrating and causes me to avoid using Smartsheet,…
-
Update Requests - advanced fields selected - their sequence
Not sure if I am going mad (or already there) but I thought when creating an automated update request -> selecting advanced options -> selecting fields to be displayed that...... the fields appeared in the sequence they were selected. However, this week, when the update request is received the fields are in the sequence of…
-
Conditional Formatting with color icons
I have conditional formatting setup up to trigger color coding to identify if a project is on schedule, in risk of being late, a major concern, etc. I then created an additional column to have the RYG icons so that I could filter the rows by color. Is it possible to tie those two in together? Basically I want Smartsheet to…
-
Feature Suggestion - Webform
Hi Team, I have a Smartsheet that has custom forms for each team member. Some team members choose to use the forms, and some choose to enter into the Smartsheet directly. What would be really great is to be able to ID WHICH form the line was entered from. Right now it just says "web-form@smartsheet.com" but can we tag it…
-
Gantt Bar Conditional Formatting not performing as expected
Hello Community, I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars. Here is my conditional formatting You can see below that I specify a change in row color and Gantt bar color based upon values in booSummaryRow. The…
-
How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows.…
-
Formula for Quarterly Revenue
Hello, I have been attempting to calculate the projected revenue for the quarters. I am at a loss. Just need to find the revenue for each quarter. I provided some of the information that I am looking at. The formula I used is returning a 0; I fee like I'm close but just can't seem to get it. =SUMIF([Weighted…
-
Are there search capabilities in a published sheet?
I would like to have the search option in a published sheet. Is this possible? My sheet has many categories with the option to expand under each, for a specific subject. It would be nice to have a search option available, as it is in the original sheet for the ease of finding information.
-
Automated rules for lines do not transfer into reports
Hi Community! I have created a report in Smartsheet that shows me all my open tasks across all sheets. If the date on a sheet is in the past, the corresponding line turns RED. Unfortunately, this is not automatically carried over into the report. Is there a common mistake i made?
-
Why do some columns (fields) not appear in a new form?
Hi, I'm a new user. I created a Smartsheet with roughly 60 columns for a survey form, but not all of these appear when I create a form. Forty-eight (48) of these columns are Dropdown (Multi Select). Each column represents a month of the year for 4 different categories, so that is why there are so many. In other words,…
