-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Search and Replace, Conditional Formatting
I have multiple columns with a variety of drop-downs on many sheets. Conditional formatting is set to many of the columns based on the drop down selection, sometimes up to 40 statements. The problem I'm faced with is if I change one of the drop down selections (abbreviate a selection for example) that is currently being…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Paste raw data into Filters
I love the Filter for "Show rows that match" is one of "select values". I however would love to be able to paste from NotePad, Excel, an email, etc a list of values separated by line or comma (IE: 5045,5046,5097,6014,5058) to automatically have that select instead of having to scroll down to select the 50 lines I want…
-
Turn off Auto-Save on Android App
Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait untill it has saved. is it possible to turn this off, and maybe just save it when required, or when you leave the sheet or…
-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
Auto Sorting a column By date
I would like to sort my rows by soonest date automatically. I can do it manually but my issue is when other people have a filter on and save it scrambles the whole sort so i have to manually sort everytime to priorities rows. any ideas?
-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…