Discussion List

• Keyboard shortcut to delete a row

  In Formulas and Functions

  Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the dev…

  Cathy Cao

  07/17/21

  Accepted

  430 6

  Accepted Answer 430 views 6 comments 2 points Most recent by Gareth Davies 07/17/21Formulas and Functions
• Are there plans to allow the API to create forms?

  In API & Developers

  I was wondering if you plan to include the forms object in the API anytime in the future? I have a need to create sheets and forms at  the same time. Thanks, David

  davidroy

  06/25/21

  207 3

  207 views 3 comments 2 points Most recent by Metan Patel 06/25/21API & Developers
• Auto populate a cell when inserting a new row

  In Formulas and Functions

  Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new ro…

  RSP

  06/15/21

  Answered - Pending Review

  80 3

  Answered - Pending Review 80 views 3 comments 0 points Most recent by RSP 06/15/21Formulas and Functions
• Total Cost Based on Date of Task Being Finished

  In Formulas and Functions

  I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily acc…

  gdavid.theflyer

  06/01/21

  162 3

  162 views 3 comments 0 points Most recent by Genevieve P. 06/01/21Formulas and Functions
• Dropdown Multi select - ~If formula

  In Formulas and Functions

  Hi all,   Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few column…

  Jose da Silva

  04/23/21

  1872 8

  1.9K views 8 comments 0 points Most recent by Genevieve P. 04/23/21Formulas and Functions
• Arrange meetings from within SmartSheet

  In Using Smartsheet

  Hello, Is it possible to arrange a meeting from within SmartSheet - instead of using Outlook. That way one could send a meeting invitation where the SmartSheet document would be an attachment similar to Outlook process.   Thanks, Sigu…

  SHE

  04/21/21

  652 5

  652 views 5 comments 0 points Most recent by tylermh 04/21/21Using Smartsheet
• Column Number Function

  In Formulas and Functions

  Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.

  yidnek

  04/07/21

  991 6

  991 views 6 comments 0 points Most recent by Paul Newcome 04/07/21Formulas and Functions
• Integration with Oracle Primavera P6

  In API & Developers

  Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6?  We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible.  …

  Michael Maxson

  03/26/21

  961 3

  961 views 3 comments 0 points Most recent by Srija Kalavala 03/26/21API & Developers
• How to automatically remove "unmatched" datamesh results from the Target sheet?

  In Apps, Integrations, and Add Ons

  Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically remov…

  Edwina Sampler-Wright

  03/25/21

  Accepted

  101 2

  Accepted Answer 101 views 2 comments 0 points Most recent by Edwina Sampler-Wright 03/25/21Apps, Integrations, and Add Ons