Community Platform
Discussion List
-
FORMULA NOT WORKINGIn Formulas and FunctionsHI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you …
-
how do I add a calendar view in a Dashboard?In Using SmartsheetHello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
-
Managing user permissions for OneDrive folders in SmartsheetIn Using SmartsheetHello - I am new to Smartsheet, so I have A LOT to learn! Since attachments are not stored locally in Smartsheet, I need to save files requiring updates in OneDrive. Rather than maintaining OneDrive access separately, is there a conne…
-
Custom Report Format Possible?In API & DevelopersI need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For in…
-
Does anyone know how to use "Row Link" in reports?In Using SmartsheetI have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Answered - Pending Review 410 views 3 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Help with INDEX MATCH with duplicate unique identifiersIn Formulas and FunctionsHi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort na…
-
FAQ: How to mark all posts across an entire forum or in a specific category as "read"In Welcome to the CommunityAs we have now fully migrated over to our new community platform, you may see old posts being flagged as new. Please follow the below steps to mark the entire forum or specific categories as read. To mark the entire forum as read: Access y…
-
Counting Checkboxes for ChildrenIn Formulas and FunctionsGetting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I d…
-
Row edit feature and sheetsIn Apps, Integrations, and Add OnsIs there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by differe…
-
Sheet exceeded the maximum recommended sizeIn Using SmartsheetHas anyone received this error message before? What are the options for large data?