Recent Discussions
Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Announcement
Join the new group for Bridge by Smartsheet!In Premium Apps and IntegrationsWe've launched a new group for Bridge users! We hope this is a space for you to find answers to your questions, provide help to others, and connect with people with similar interests and use cases. Ask your questions about building workflo… -
Formula to Check Duplicates on a Multi-Select Drop DownIn Using SmartsheetTo evaluate each value within a multi-value cell is what has me stumped. 'CountIf' exceeding 1 is the key for single values. I thought about using 'contains'. I'm curious if anyone has figured this out.Answered - Pending Review 4 views 2 comments 0 points Most recent by JeremiahHorstick Using Smartsheet
-
My Smartsheet won't save!!!In Using SmartsheetI have tried everything, new browser, clearing cache, updating browser...this sheet only has 51 lines and no advanced formulas. Why won't it save!!!!??? (Image)
-
how to use report sheet without sharing the data source sheet?In Using Smartsheetit´s possible to have a report shared to a anyone without share the main sheet (data source sheet) Thanks,
-
Summarizing qualitative data across multiple sheetsIn Premium Apps and IntegrationsI am trying to summarize engagement types by state across multiple project sheets. What is the best way to do this?
-
What formula is needed to count specific catagories from a drop down (multi Select)In Formulas and FunctionsHi! I am hoping that someone has come across this and can offer a little insight on how I can do this. I have a sheet with a drop down column that has multi select. (Image) I want to count each time one of these selections is used and grap…
-
If this then that...In Formulas and FunctionsI am simply trying to create a formula that IF the job code is this, then it auto populates the corresponding Job Title into another cell. Is there a way to do this?
-
Data not updated in dashboardIn Using SmartsheetData in sheet is not being updated/visible in dashboard. I manually refreshed and even set auto-refresh every minute, but the updated data is still not showing in dashboard.
-
Restrict date field to only specific day of the weekIn Using SmartsheetI have a date field in my smartsheet that I need users to select a specific date, but I would like to restrict them to only be able to select Fridays. Is there any way to do that on the form? I do not want to have to prepopulate a drop…
-
COUNTIFS + FIND QuestionIn Formulas and FunctionsHi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the…Answered - Pending Review 12 views 4 comments 0 points Most recent by Matt Scroggins Formulas and Functions
-
Lookup formula instead of valueIn Formulas and FunctionsI am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?
