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
-
Count FunctionIn Formulas and FunctionsMy excel spreadsheet that I'm attempting to replicate uses the following formula to count if any value is listed in column M. =COUNT(All!M:M). So if I have 3 items/rows listed in Column M it would return a 3, regardless of the value o…Answered - Pending Review 15 views 1 comment 0 points Most recent by Darin Wagner Formulas and Functions
-
Count if older thanIn Formulas and FunctionsTrying to count the number of dates that are older than "Todays" date by 14 days. So if today is 4.16.21, anything that was listed in my date column that is 14 days older than 4.16.21 would be counted. Example: Date Colum has 2 r…Answered - Pending Review 14 views 1 comment 0 points Most recent by Darin Wagner Formulas and Functions
-
Parent Child FormulasIn Formulas and FunctionsGood morning! I have child rows with column formulas to find the average from other columns. Is it possible to add a parent row formula to find the average of the child rows? Hard to explain hopefully the image will help. The parent row …
-
Data validation for multiselect dropdown lists?In Using SmartsheetI am embedding a Smartsheet form in an online training module, to collect and validate the answers in the absence of an LMS. For a single dropdown, I found it easy - I create a question column, in which I collect the answer, and an answer …
-
Dynamic View Attachments in Mobile ViewIn Premium Apps and IntegrationsWhen viewing Dynamic View on a phone through a mobile browser, is there a way to add attachments? I see the option to add attachments on the desktop view, but not in the mobile view.
-
Stacked Bar Chart with PercentagesIn Formulas and FunctionsHi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the …Answered - Pending Review 26 views 18 comments 0 points Most recent by Sophie Knudson Formulas and Functions
-
Lock Request Update ActionIn Using SmartsheetIs there a way to lock/stop being able to use the button sent in a Request Update Action in the workflow? For example this button gets sent via email and after a certain date if they click that "open update form" button, I want t…
-
New Dashboard Editor/ViewIn Using SmartsheetWe are using dashboard views of data, where the underlying reports have a criteria based on the current user. Typically if these reports are empty they would show as such in the dashboard. With the new dashboard editing tool these report…
-
Help on formula: count if with multiple criteriaIn Formulas and FunctionsHi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
-
Calculate days between first and last instanceIn Formulas and FunctionsNeed help calculating the number of days between an items first entry on a list to it's latest entry. List is populated via Forms with newest entries at top of list. For example below (in yellow) would return 84 days. If possible, would li…