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
FEATURE REQUEST: Row coloring moves between views.
I have a feature request. It would be extremely helpful to have the row background color move between the different views (grid, calendar, etc.). When I have color coded a particular row in the grid view, I would like to have that same color show up on the calendar view.
Webform to generate Order Number?
Is there a way for the Web Form to generate an order number when submited? Or a function to give a a row an order number?
Reverse COUNTIF / COUNTIFS
I have a list of 200 items. I want to count the ones that are NOT "Jimmy" =COUNT([columnA]:[columnA] - COUNTIF([columnA]:[columnA],"Jimmy") But I have a second column that I need to know the NOT "Jimmy". what I would like is COUNTIFS( not this::: ([columnA]:[columnA],"Jimmy"), and this ([columnB]:[columnB],"Maryland") )…
Conditional exclusion of rows
I want to have a sheet where based on a condition like a checked box certain rows are or are not available. For example if CAPEX is not checked then the Capex task rows are not available to see. Is this possible
Limitations on design - Can I put a forumula in a cell in a date column
Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on a sheet a column is a date or drop down etc. and I want to use a cell in that column in a…
Conditional actions
Is there a way to make it so that when status is marked complete the row automatically moves to another designated sheet?
Authentication to Web Request Forms.
Hello All, Our IT Department does not like that any registered user of smartsheets can access the web request if the have the url. The solution would be a username and password authentication to allow access to the Web Request that allows only who we want to have access to it. Doe anyone have a solution?
Kudos: New look
I like the new look to the Support Center. https://community.smartsheet.com/support Easier to navigate. Well done. Craig
Why can't I see zeroes?
I've got a long formula that determines an IP address for a computer. That formula should result in a formula for an IP address that looks like this: 10.20.12.32 However, when there's a zero entry, SmartSheet is omitting the zero, so the result looks like this: 10..12.32 I need to show the zero! If I type a zero in a…
How do I convert Text (from a count) to a number?
Figured out how to use the COUNTIF to get a count within a column if a box is checked it contains a certain text in a dropdown, by changing the results to text (e.g., ...+""). However, what appear to be numbers are acutally text and I cannot sum them. Any suggestions how to convert? Thanks
