-
IF FORMULA HELP
Here is my IF formula: =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow")) It works great for green and everything else not so much. What I want it to do is calculate based off of percent complete. so if less than 50% complete it should be red, if less than 75% yellow everything else is green. What have…
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Anyone else experiencing an issue with Card view details?
Steps to reproduce: 1 - Change a sheet to "Card view" 2 - Open one of the cards to view the details 3 - Scroll down to a field and click inside the cell 4 - Does the details window anchor back to the top thus not allowing you to click in the details field? If so, I logged a request for this just now: 03425917 I had an…
-
Trouble with Calendar App Group Data
Hi! I am having trouble with the Group Data By function and using the Custom Category List Order. Some columns that I sort by allow me to choose custom colors while others do not. Is there a reason why some columns allow sorting by color and others do not? How can I identify which columns will allow sorting by color?…
-
Alphabetize Filter Options
In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, see a scrollable list of project managers - out of order - How can I alphabetize this list?
-
Sheet content, shifting rows
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easier). Today, I noticed that the columns in between have shifted down a few and the further I get down them worst it gets…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
SUMIFS with multiple matches
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 2019 and the value in a cell in column 4 is 4.. I.e. for any rows where there is a match for - deal id is not blank, where…
-
Support function on account?
Hello, I have raised a ticket twice for the same issue and have yet to receive any reply a month later. I have taken a screenshot the second ticket raised to capture date and ticket number as nothing was received for the first ticket created. The issue itself isn't a huge problem, I am more concerned that we have no way to…
-
Limiting the dates that print in Smartsheet
I want to create a Smartsheet project that has a Start Date of July 1, 2019 and End Date of September 1, 2020. I want to set the timeline to Years/months. When I view or print it, I only want to see the months associated with 2019 and 2020 and I don't want to see any months in 2021. How do I do this? I can't hide the…
