Sheets

 

Discussion List

  • Adding detailed information to a row / task
    In Using Smartsheet
    I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do …
    Unanswered
    15 0
    Question 15 views 0 comments Started by delberto Using Smartsheet
  • How to attach notes to a line item
    In Using Smartsheet
    Hi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit…
    135 4
    135 views 4 comments Most recent by delberto Using Smartsheet
  • Using Countif in place of Autonumber - formatting question!
    In Formulas and Functions
    I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Mike TV Formulas and Functions
  • Date/Time Stamp Option
    In Formulas and Functions
    While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not sc…
    2731 17
    2.7K views 17 comments Most recent by Chris Rolando Formulas and Functions
  • How can I use Salesforce to create a new Smartsheet from a Smartsheet template?
    In Apps, Integrations, and Add Ons
    We want to use the Salesforce Connector to link data from individual smartsheets back to individual Salesforce records. However, we don't want to have to create a Smartsheet connector Workflow for each individual Smartsheet sheet, since we…
    Unanswered
    14 0
    Question 14 views 0 comments Started by sadie_ch Apps, Integrations, and Add Ons
  • Formula to automatically link Week to Date
    In Formulas and Functions
    Hello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attach…
    Accepted
    21 7
    Answered ✓ 21 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • PMT calc
    In Using Smartsheet
    Is there a similar function to PMT? =PMT(rate, period, pv, fv) etc? Have not been able to find one. Thank you.
    130 3
    130 views 3 comments Most recent by Ivan Bowskill Using Smartsheet
  • Add Column to Row Report that was not in original sheet
    In Using Smartsheet
    Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…
    Answered - Pending Review
    946 8
    Answered - Pending Review 946 views 8 comments Most recent by rvogler Using Smartsheet
  • Including Half Day Holiday to Timeline Nonworking Day
    In Using Smartsheet
    Is there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)? https:/…
    Answered - Pending Review
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by mpomerantz Using Smartsheet