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 March 2017
Discussion List
How do you write formula so that IF checkbox is checked, the percent complete is 100%
I am trying to make it easier by having a checkbox = 100% rather than manually writing 100% to fill out my gantts I have failed at this. The name of my checkbox column is "Done" So what should my formula look like? All of these are failing '=IF([Done15 = 1], 100%) =IF([Check Column] = 1, 100%) Help?!
Amazon Web Services
Is the S3 vunerability patched yet so that we do not have a repeat outage like we did at the end of February? Or are we still at the mercy of AWS?
Bug: Auto-Save has unexpected results
Please see my comment and description of the bug here: https://community.smartsheet.com/discussion/summary-report-multiple-sheets-modified-date?page=1#comment-19340 When auto-save after 3 minutes is on, a sheet with the TODAY() formula in use will auto-save on initial open after a few seconds. While this may be a…
Sort while Filtered
Where do we stand with the ability to Sort while Filtered? I've seen this mentioned as a feature request before. This really is a shortomcing. This would be especially useful when dealing with Task lists. I don't want the completed tasks deleted, but I want to filter them out, then sort by due date. Unfiltering to sort,…
Sort by month?
I'm looking to create a report of products that will ship by month. I can't get a report to sort by month, is there a better option?
Chart on Sights
Hi, I created a chart on SS labs. I want to display the chart on my project dashboard. How can I do this? Y
Web Forms: Capture confirmation email into a column
Hi all, When using web forms, I'd like to capture the email address entered in the confirmation email field into a column in my smartsheet. Does anyone know if this is possible?
Can I stop auto delete data in cell
I lost my data in the cell that I choosed it. When I select the cell that has some data for a while, text will disappear. I have to undo to get data back. I am not sure, this is only my problew or another users have it. Please fix this problem as soon as possible cause it is very unconvenience for users and has high risk…
Generate a word in a column if an item is added to a list
I am trying to build a formula so when a number is entered into the Lot Number column, the cell in the next column over (Lot Status) will automatically generate the word "Available". I have tried the following formula with no success: =IF([Lot Number]:[Lot Number] = 1, [Lot Status]:[Lot Status] = "Available") Please note,…
Sending Row from Report - Selecting Columns
I want to use the 'Send Row' function as a confirmation to clients that certain tasks were completed. The Report includes about half the columns from the Referenced Sheet, but I only want to send 4 or 5 columns and no attachments with these confirmations. So I clicked the "Edit" button to deselect the columns, and I ran…