-
Add another column/type of data to my Gantt chart?
Hi there, I'm trying to figure out a way to add another column's info to the Gantt chart. For example, we're tracking my org.'s grant cycles. So for the Primary column, I've used "Organization Name " for the funder (i.e. Hewlett). For the label, I've used program (which program the grant is for, i.e. Environmental Equity).…
-
Strange behavior with autocomplete today (unexpected, erratic)
Some formulas auto completed today. Some didn't. Or appeared to move down a single row maybe? I don't see a pattern just yet. See uploaded pics. Notified support as well. Anyone else experience this? I'm off to correct 1k plus rows...
-
Generating an alert for a Value <0
I have setup in an alert to alert me if the value is less than or equal to 0; however it isn't triggering the notifications it should. Any thoughts?
-
Workaround for limiting access to douments
Hello, We will likely have some smartsheet project plans that we'll share with clients, however there will be documents that we won't want them to see/access. The standard permission model is you have access to all documents if you access to the sheet. With that parameter, we do have a "not the most ideal" work around to…
-
INDEX and MATCH #invalid value error
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
IFERROR Formula Help
I would like to be able to count symbols in a column, even if there is an "#Invalid Data Type" error in one or more of the cells in that column. Will the =IFERROR formula help me? Here's what I'm working on: I am trying to determine whether or not a project has been completed early, on time, or late based on the date it…
-
Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
-
I am trying to create a survey that tracks each person's responses (NOT anonymous survey) - anyone k
I'd like to create a survey in Smartsheet that links a person's responses to their name/email. Additionally, is it possible for Smartsheet to send alerts/reminders to only those people who have not responded to the survey yet? Thank you!
-
Outlook 2016 - Cannot authenticate smartsheet in outlook 2016
I have installed the smartsheet plugin for office 365. I can authenticate the plugin via the browser version and use the app, but am getting permanent hang when trying to authorise the desktop version. I get as far as the allow/deny screen, then I get stuck on: https://smartsheet-outlook.herokuapp.com/outlookapp/closeMe…