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 2017 Posts
Archives for February 2017
Discussion List
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
IFERROR
The formula underlined works perfectly when there is a date in the relevent cell. When their is no date (data) it returns a error. Ive had a go at trying to figure it out below. =DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2) + 1, 20) =DATE(YEAR,IFERROR([Invoiced Date]3),""), MONTH,IFERROR([Invoiced Date]3),"-"), +…
Auto Update Request based on email contained in a specific column
I have a sheet of 30 rows and would like to send daily email Update Requests based on an email in one of the columns. These people are not in my contact list. Is there a way to 'bulk' issue this command for all 30 plus rows or do I have to issue 30 commands. Hope this makes sense. John
Feature Request: Ability to Modify the Working Days of Specific Line Items
While building out a Gantt or waterfall chart in Smartsheet, it is not uncommon to have some tasks that can only occur during a weekday while others can occur on weekends. It would be great if one could modify the working days at a more granular level, that is the ability to edit the working day property of each line item…
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
Web Forms - Can these be customised further
Hi Can the forms be customised to allow a better layout -? for example if you have 5 radio buttons then these warp on to the next line and this looks messy. Is there any control over CSS? Thanks
Sights
I am using smartsheet to collect problems and ideas coming from various areas of our company. As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas. My query is where is the best place or method to gather all the…
Copy Sharing when duplicating (Save as New) sheet.
We create (copy) a new sheet each month, keeping all the formatting but not the attachments and comments and cell lnks. Is there a way to duplicate the sharing as well. The sheets are in the "Sheets" folder. I have created a Workspace with the sharing, but when I move or copy the sheet to the "Sheets" folder, the sharing…
Sum using symbols
Can I sum the columns where I used a symbol to show the value? for example - if I use the Stars Symbol for 'Size of effort' - Empty stars = 0, 1 Star = 1... and the Faces for 'level of urgency' - No Pain = 0; to Extreme Pain = 5 the total Size + Urgency should be ~ 1 star + Extreme pain = 6 If I use the basic sum formula…
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…