-
Report Builder not showing all column options
I've been trying to pull in some additional columns into a report from the same sheet that the other columns are pulling from. When I click on 'What?' in the Report Builder, it does not show all of the columns as options. They are columns with dates and are no different than other date columns that show up as options. I…
-
Can you use an "IF" function with a dropdown?
I have a dropdown list in one column with 5 options to select. I want a Text/Number column to produce a designated value based on the option selected from the dropdown: Dropdown contains : Project, Small Project, etc. Values would be Project = 10, Small Project = 9 Every attempt tells me #UNPARSEABLE. What am I doing wrong?
-
Hyperlinking email addresses
Is there a way to link email addresses so that they open to outlook, gmail, etc. using smartsheet? I want to link emails on my sight/dashboard for who to contact about certain areas and that requires the viewer to copy the email and then paste it in their email. I know in other applications you can use mailto:insertemail…
-
Change week start day for resource views
Hi, We have changed settings everywhere we can find to have our work weeks start on Mondays. This has worked for sheets and reports but we can't find anywhere to change the start day of the week for resource views to Monday instead of the default Sunday. I can change the time period to start on a Monday but the following…
-
Change color of task rollup bar
For groups of tasks, the overall heading bar for the group is always gray. I'd like to change it's color to signify status (red, green, yellow). Is this possible.
-
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.
-
Audible alert
Does Smartsheet have an audible notification feature? For example, if I have the smartsheet open, yet minimized on my computer, and someone makes an entry, is there a “ding” sound that would tell me that an entry was made? Or if I have smartsheet open on my phone, and an entry was made, would my phone make a “ding” sound?…
-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
How to configure my own Email as Smartsheet Notifications Email Address
Hi, I want to configure my own email address to send notifications to team. How can I send the notification from my email instead of notification@smartsheet.com. If the feature is not supported in Smartsheet, what workarounds are available for it?
-
Conditional Formatting based on system columns (Attachments and Comments)
I can't find any discussions on this. I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row. For attachments, I would like the criteria based on: - Changed: If the list of files has changed at…
