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 2016 Posts
Archives for February 2016
Discussion List
Select "No Background" in conditional Formatting
I want to clear the background of a specific cell when it is set to a specific value. But when I do that with conditional formatting I get this error message when I select "No Background" If I select white as background or any other color, then click OK it works. Any idea if that is a glitch in the system or if that…
Control type symbol to measure 1-6 levels?
I would like a control type symbol for a column to measure 1-6 levels. I see several symbols that measure 1-5 but none that can be expanded to measure 1-6. I would like one status for indicating where in the process of completion a task is currently. I see only up to 5 so now do I have to provide a status for each phase of…
Creating & Reusing a blank template I made
I have created a blank template. The template is saved in my "Sheets" folder. Everytime I need to use that particular template do I just drag it into my Workspace folder in order to use it? Does the blank template remain in my Sheets folder to future use?
Smartsheet stability issues
I've been a smartsheet user for only about six months, and up until recently, Smartsheet's stability and system uptime has been impressive. The only recurring issue that I have is an intermittent error message "cannot display the available resource view" that is still plaguing us. However, lately (within the past 2 weeks)…
Can you sort rows or filter in the iOS app?
I am trying to sort a list from ascending to descending in the iOS app. Or filter out values less than a certain number. Seems like this would be very standard functionality for a spreadsheet. Am I missing something? Any help would be greatly appreciated.
Can If-Then formula populate Primary column?
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
Can you link drop boxes in a web form?
I want to be able to select your name and your assigned support person populates the next block
Anybody else having trouble with reports this morning? Did checkbox behavior change?
I have reports for each team member and the tasks they are assigned. The reports are now missing the majority of the tasks assigned to that person. (Not all). I have checked the source data and the report filter criteria. Nothing has changed. I cannot get any previously created tasks to show in their reports. The only way…
Single-row reporting from multiple sheets
In the reports I've used so far a new row is created for each sheet data is pulled from. Is there a way of combining the results on one row where the primary column is the same? For example, if I have project RAG status in Sheet1 and project financials in Sheet2, and both sheets have the identical project name as the…
Manage time entries based on previous ones
Hello! The use case I am trying to enable is that when a user makes an entry it should not exceed a set cumulative time (eg 120 minutes). So user 1 enters 90 minutes, user 2 enters 40 minutes in the cell below it which exceeds the alloted time by 10 minutes. Can this trigger a warning or validation that prompts for a…
