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
Custom formatting - individual cells
Excel has the functionality to define custom formats by cell - for example, you can say that for each cell in a range, if the cell value is negative, then the font colour will be red, otherwise it will be black. Does smartsheet have this functionality? So far I can only see fuctionality to format an entire row based on a…
:% Completion Drop Down freeze
We are unable to use the drop-down option to update the % completion of our projects but it allows us to manually update it. It has being like this for about a week. How do I fix it?
Formula(s) to select & show project status
For each project sheet, I show the total number of tasks over due (red), due within 7 days (yellow) and not yet due (green). Now I want to create an executive report that shows a red, yellow, or green light for each sheet based on the category that has the highest number of tasks. Ultimately, the executives will receive a…
Admin Control/Push Font Across Workspace/s
I would like to control and update the font for all sheets in every workspace. For example, I would like to change all data in workspaces/sheets to be Verdana 10. Right now we have different fonts across sheets. Then allow Contional Formatting be the only way for fonts to be altered. As admin can we have control over this…
Web Forms Client Input
I run a construction company and I require information from the client regarding decoration specification, colours etc. I have created a Smartsheet and need to get the client to fill out the information. Screenshot below What is the best way to get the information from the client ? Share the sheet? Only problem is I can’t…
sort save and undo
Can I raise a serious flaw in Smartsheet. Saving after sorting can not be undone. This is a big issue for large sheets containing data. I have a client who inadvertantly saved after sorting and now had to spend 2-3 days redoing all the inputtng for the sheet in the format they wanted. The workaround we had AFTER we fixed…
Salesforce & Smartsheet integration - access to other users' sheets
Hello All I've configured the integration between Salesforce org and Smartsheet account. During configuration process I provided Smartsheet account with SysAdmin priviliges (this is required step). Let's call this account "TEST_Smartsheet_admin" Now I'm logged as regular end-user in Salesforce and I'm trying to add…
URL direct into Card View....or make card view the primary view?
I have a lot of team members who struggle with new tools. The card view is VERY easy for my team to navigate and quickly shift items around. The problem is that the link I provide for them to access the Smartsheet always defaults to the standard spreadsheet view. I get calls of confusion because they forget how to toggle…
Automate Day based on chosen date
Hi users! I have a coloum that the user selects the date for a particular job. The following Column requires that DAY of the week to be selected. Ie: if I choose the date 19/12/16, i then have to maually select 'Monday' from the drop down list. Is there a way to automate that day of the week based on which date I select in…
Client Contact List TEMPLATE
Is there no way to link this Template to the "Contacts List" dropdown? Or be able get the "first name" (there is only one field currently for My Sheet contacts) from the sheet contacts list to be put in another field
