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
-
Report access without base sheet level accessIn Using SmartsheetHi, I have a user that needs access to a report (which filters the data based on a parameter and only returns certain rows). However it doesn't seem like they can view it unless: I make the report public, which isn't an option as it conta…
-
Dashboard ViewerIn Using SmartsheetSmartsheet, please can you give your rationale for removing Dashbaords viewer from the home page? This was really helpful as I could see all my dashboards in one place. I now have to search a dashboard and as we have so many, I don't alway…
-
Dynamic view - 'Save' button is greyed outIn Using SmartsheetHello all, When I create a dynamic view and try to make any change to the data in it after that the 'Save' button is greyed out and it is impossible to save any changes at all.
-
Pulling data from a sheetIn Formulas and FunctionsGood Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that rec…
-
sequential number for each parent row - column formulaIn Formulas and FunctionsHello im trying to generate a sequential number for each parent row. I can do this using an helper column called parent that flags each parent record with 1 then the formula @row, 1) this won't convert to a column formula because of the ex…Answered - Pending Review 10 views 3 comments 0 points Most recent by David Tutwiler Formulas and Functions
-
Accounting for the word "Perpetual" in a date field when there is no end dateIn Formulas and FunctionsI am currently running this formula: =[Contract Expiration Date]@row - [Notify days to renew/cancel]@row to calculate the date when we need to review a contract. It essentially takes the end date of the contract and subtracts the numbers …
-
Help with Countifs formulaIn Formulas and FunctionsHello, I need help with the last part of the below formula( {Region}, "US" OR "CAN) ). I am referencing a column called Region on a sheet and I need the count to include if it has US or CAN listed. Please help in how I can …Answered - Pending Review 11 views 1 comment 0 points Most recent by David Tutwiler Formulas and Functions
-
using COUNTIF to find exact numbers.In Formulas and FunctionsI've been using COUNTIF to count the number of occurrences in a month. So i've got a list of 'events' throughout the year, all with different dates. I'm wanting to count how many are in each month. What I've done is to use the MONTH formu…Answered - Pending Review 24 views 2 comments 0 points Most recent by David Tutwiler Formulas and Functions
-
Children reporting to parent - Checkbox and checking statusIn Formulas and FunctionsHi guys! I'm having a hard time figuring this out. I've tried to copy and edit all the formulas in this forum, so now I'm just asking the pro's. (Image) Two questions: I need to have the cell marked 1. on the picture check the children cel…Answered - Pending Review 9 views 1 comment 0 points Most recent by David Joyeuse Formulas and Functions
-
Please help with lookup / index formula where there are multiple instances of the search valueIn Formulas and FunctionsHi All, I am new Smartsheeter and having difficulty in finding the correct lookup / index formula where there are multiple instances of the search value. I have tried a formula which works in excel (Index / Small / Row), but "ROW"…Answered - Pending Review 10 views 1 comment 0 points Most recent by David Joyeuse Formulas and Functions
